Return Blank Cell in case of false If

[yashkee]

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.

 

[Pete_UK]

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(A1>0,A1,NA())

Hope this helps.

Pete

 

[Khoshravan]

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,"")

 

[Ashish Mathur]

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