Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a Cell Blank
How can I change this formula: "=IF(J34="","",IF(L34-J34-Q34=0,"",L34-
J34-Q34))" so the cell will be blank if it is 0 or less than 0? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a Cell Blank
Maybe...
=IF(J34="","",IF(L34-J34-Q34<=0,"",L34-J34-Q34)) Notice the new comparison in that second if portion. Bob wrote: How can I change this formula: "=IF(J34="","",IF(L34-J34-Q34=0,"",L34- J34-Q34))" so the cell will be blank if it is 0 or less than 0? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a Cell Go Blank | Excel Worksheet Functions | |||
Making a Blank Cell | Charts and Charting in Excel | |||
Making a cell show blank until data is entered | Excel Discussion (Misc queries) | |||
Making a cell blank or empty without deleting it | New Users to Excel | |||
Making Cell Blank | Excel Worksheet Functions |