Stephanie, I messed this up, mostly because I have made a change.. Please let
me restate:


I would like M Column M4:M100 to be the +/- the numbers down I4:I100 "I"
column is driven by what I type in H.

L is the target L4:100

ie: If L20 is 25 and I4 is 18 then M4 is +7 or 7
If L4 is 20 and I4 is 14 then M4 is -6

AS I4:I100 gets a new #, L changes. (it's and average)

Can you help me make (M4:100) be +/-) I column)
I would like the old M4:M100 to move to N4:N100,
Then the old N4:N100, to move to O4:O100,
and Old O4:O100 drops off.



"Stephane Quenson" wrote:

I am not sure that I understand the question, but let me try answering it
anyway :-)

If I4 contains 25, you want M4 to contain -25, if I4 contains -25, you want
M4 to contains 25. In that case, put =-I4 in cell M4.

If I4 contains 25, you want M4 to contains -25, if I4 contains -25 you also
want M4 to contains -25. Then the formula is =-ABS(I4)

Let us/me know if this is fine or not.

Stephane.