IF Statement help

[help!]

=IF((C29-C26)>=0,C29-C26,0)
This a IF statement that returns a decrease in an amount with a positive
number

I used:
=IF((C29-C26)<=0,C29-C26,0) for the increase in amount, however if there is
an increase - it returns a negative amount. For example -10 000.

I want this increase to be stated as a negative amount. How can I fix this?

thanks!

 

[Mike H]

Maybe,

=IF(CC6<C29,C26-C29,C29-C26)

Mike

 

[help!]

That does work but I still want to put a "0" in the cell if the increase is a
- amount..

This did work and put the increase as a positive amount. thank you

 

[Gaurav]

=MAX((C26-C29),(C29-C26),0)

might work.

That does work but I still want to put a "0" in the cell if the increase
is a
- amount..

This did work and put the increase as a positive amount. thank you

 

[David Biddulph]

=IF((C29-C26)>=0,C29-C26,0) could be =MAX(C29-C26,0)

=IF((C29-C26)<=0,C29-C26,0) could be =MIN(C29-C26,0)
If you want to reverse the sign, then =-MIN(C29-C26,0) or =MAX(C26-C29,0)