View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JNW JNW is offline
external usenet poster
 
Posts: 480
Default If statement help

=IF(C29-C26=0,0,C29-C26)
--
JNW


"help!" wrote:

my if statement is =IF(C29-C26=0,0,) However, how do I put in the actual
amount in this cell if C29-C26< 0? Not sure how to do this?

thanks in advance!