| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
An if statment tat returns a true blank
I need an if statment to return a true blank. I currently have
=IF(C129<0,C129*-1,"") as a formula, when fales it returns an empty cell that returns #value when used in calcuations. I do not want it to return a zero value, nor can I turn on the option to leave a cell blank for a calculated zero value, due to other calculations that I need to return zero. Thanks is advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula returns blank | Excel Worksheet Functions | |||
| If Statement returns true when false? | Excel Discussion (Misc queries) | |||
| Code returns TRUE instead of value | Excel Discussion (Misc queries) | |||
| How do I highlight a formula result (IF statment=True) | Excel Worksheet Functions | |||
| First part of "IF" function returns false even if true. ?? | Excel Worksheet Functions | |||
Threaded Mode
