| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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..? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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..? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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..? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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..? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If result of formula is zero disgard it?
Cool !
Regards, Peter T Another... =MAX(P5+Q5-R5,0) - - - Dana DeLouis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula result and displayed result are different | Excel Worksheet Functions | |||
| Formula result does not match displayed result | Excel Worksheet Functions | |||
| Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Linear Mode
