Thread: IF statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default IF statement

Hi,

You could use IF but don't need it, try this

=MAX(0,C29-C26)

Mike

"help!" wrote:

I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell
to display 0.

Can I use an IF statment for this? How would I do this?

thanks!