Return Blank Cell in case of false If


Y

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.
 
Ad

Advertisements

P

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
 
K

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

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top