Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Blank Cell in case of false If
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Blank Cell in case of false If
You need to return the function NA() in your false part - this is an
error (shows up as #N/A), but it will not show on your graph. Example: =IF(A10,A1,NA()) Hope this helps. Pete On Feb 5, 3:11*pm, wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Blank Cell in case of false If
Use: IF(logical_test,value_if_true,value_if_false)
If you want a blank to be returned in false case, put "" for value_if_false so formula looks like: IF(logical_test,value_if_true,"") -- R. Khoshravan Please click "Yes" if it is helpful. " wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Blank Cell in case of false If
Hi,
One of the features of this application is that it charts only the visible data points. Therefore, in whichever column you have the formula, just filter that on either values greater than 0 or TRUE and then when you plot a chart, you will see that the 0's or FALSE's do not get plotted. Please note that this is not a dynamic solution I.e. if the 0 becomes 0 or <0 or FALSE becomes TRUE, you will have to remove the filter. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |