Thread: IF sum is GreaterThan 0... why wont this work!?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default IF sum is GreaterThan 0... why wont this work!?
SteveG wrote...
Try this.

=IF(SUM(G56-L4-N6)<=0,0,SUM(G56-L4-N6))

Does that help?

Why use SUM? Why use IF?

=MAX(0,G56-L4-N6)

should produce the same result.

Reply With QuoteReply With Quote