View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel0511 Daniel0511 is offline
external usenet poster
 
Posts: 1
Default If result of formula is zero disgard it?

I have a spreadhseet for setting up a reserve?

In cell S5 I have the below formula

=SUM(P5+Q5)-R5

if R5 is greater than (P5+Q5) I obviously get a negative which in turn
screws up my next formula.

How do I get S5 to present a zero if formula result is a negative..?