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