| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell subtraction
In E17 I placed =If(isblank(A17),"===",B17-C17)
In A17 I have the date 4/4/05 In B17 is the negative number -30.33 In C17 is the number 0.00 In E17 I get 30.33 instead of -30.33 How can I fix this to get -30.33 in E17 Also if A17 is blank/empty and B17 is empty and C17 is 500 then I get #VALUE! in E17 instead of === |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Threaded Mode
