add or subtract numbers in one cell dependig which numbers in another cell

Hello,

I need some help with creating a macro that adds or subtracts numbers in one cell dependig which numbers in another cell.

For exampel: In cell W9 the value is -3,9 and the value in cell E9 is 0, then I want my macro to add 4 in cell E9.


In my document, cell E9 controlls how many units I have to order depending on the ingoing buffer in cell W9.

Cell E9 is always gonna start with the value 0 and should never have decimals.
Cell W9 is gonna start on any value (depending ingoing buffer) over or under zero.
The macro has to end when the value in cell W9 is between 0 and 1.

Looking forward to some good answers

//Peter

Why not use a formula?

=IF(W9<0,-ROUNDUP(W9,0),ROUNDDOWN(W9,0))

That doesn't work

Originally Posted by Chris 53

Why not use a formula?

=IF(W9<0,-ROUNDUP(W9,0),ROUNDDOWN(W9,0))

The reason I can't use this formula is that I get a circular reference because cell W9 is connected to cell E9 with another formula.

Help me please!