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..?

If result of formula is zero disgard it?
 

Try the below formula in S5:

=If(SUM(P5+Q5)-R5=0;SUM(P5+Q5)-R5;0)

Nathan

"Daniel0511" wrote:

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..?

If result of formula is zero disgard it?
 

Most users will probably need to replace those semicolons with commas

here's another one (not sure why SUM was needed)

=IF(P5+Q5-R5<0,0,P5+Q5-R5)

Regards,
Peter T


"Alogon" wrote in message
...
Try the below formula in S5:

=If(SUM(P5+Q5)-R5=0;SUM(P5+Q5)-R5;0)

Nathan

"Daniel0511" wrote:

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..?

If result of formula is zero disgard it?
 

=IF(P5+Q5-R5<0,0,P5+Q5-R5)

Another...

=MAX(P5+Q5-R5,0)

- - -
Dana DeLouis



Peter T wrote:
Most users will probably need to replace those semicolons with commas

here's another one (not sure why SUM was needed)

=IF(P5+Q5-R5<0,0,P5+Q5-R5)

Regards,
Peter T


"Alogon" wrote in message
...
Try the below formula in S5:

=If(SUM(P5+Q5)-R5=0;SUM(P5+Q5)-R5;0)

Nathan

"Daniel0511" wrote:

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..?

If result of formula is zero disgard it?
 

Cool !

Regards,
Peter T


Another...

=MAX(P5+Q5-R5,0)

- - -
Dana DeLouis