Blank a cell using a formula

A

asach

Here is my formula: =if(iserr(h3/g3),"",h3/g3)

The problem is I am using this data in a line chart and whenever there is a
"", the line goes all the way down to zero. Is there a way to completely
blank a cell rather than filling it with a space?
 
R

RagDyer

Try this:

=if(iserr(h3/g3),#N/A,h3/g3)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Here is my formula: =if(iserr(h3/g3),"",h3/g3)

The problem is I am using this data in a line chart and whenever there is a
"", the line goes all the way down to zero. Is there a way to completely
blank a cell rather than filling it with a space?
 

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

Similar Threads

How-To Autofill cell if cell beside it is a certain value 6
COUNTIF - Three criteria? 3
Need cell value not cell pointer returned from formula 2
Complex If/Or/And formula 7
Return blank cell using a formula 2
SUMPRODUCT formula is summing text and I want it to stop doing that 2
Cell References 1
Visual to automate formula 5

Top