crunching daily numbers

[BILL BONDO]

i am using this formula
=if(a1>a2,abs(a1-a2),abs(a2-a1))
this is what i need
day 1 = 100
day 2 = 50
day 3 = 75
day 2 should return a -50
day 3 should return a 25
i can only get the formula to show all negatives
or all positives, not both HELP ME!!

 

[Dave Peterson]

How about just:

=a2-a1
copied down.

Assuming that A1 held day 1, a2 held day 2, ...

 

[eluehmann]

=a2-a1??

 

[mzehr]

Hi,
You were close, try:
=IF(A1>A2,(A2-A1),ABS(A2-A1))