Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all,
I came upon this problem and would like your kind help. I would like to use the if function on a specific cell, and I don't know how to return blank cell in case the value of the IF function is false. It can't return zero or false since i am using this cell in a graph and once it determines the falue zero the graph is changed radicaly without any logic (eg, the previos value is 100K). However if i delete the value manualy and leave the cell blank it does not affect the graph. Or if there is any other viable solution, I would highly appreciate it. Thank you in advance, Jetblue. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
IF function - need FALSE to return a blank cell, not 0 | Excel Worksheet Functions | |||
keep cell blank if IF statement is False | New Users to Excel | |||
Keep cell blank if condition is false in IF function | Excel Discussion (Misc queries) | |||
keep cell blank when false in IF statement | Excel Discussion (Misc queries) |