View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HELP! HELP! is offline
external usenet poster
 
Posts: 8
Default IF Statement 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!