Truly Blank Cell Possible with Formula?

  • Thread starter Thread starter Mathew
  • Start date Start date
M

Mathew

Hello all,

I am trying to create a formula that will return a truely
blank cell if the denominator cell is blank. The results
of the formula are feeding an excel chart. And because
the "" returns a text field the chart thinks that the
value is zero. But if i could come up with a formula that
returned a truely blank field the resulting Excel chart
would skip the blanks. I am using Excel 2000. Below is
what i have to this point. Any help would be greatly
appreciated!

Thanks
Mathew Doyle

=IF(ISERROR(B3/C3),"",B3/C3)
 
Replace "" with NA()
it is obviously not a blank but it will work
as opposed to ""

you can also rewrite your formula as

=IF(C3=0,NA(),B3/C3)
 
Hi
in addition to Peo's suggestion you may hide these 'error' cells with
conditional format. Say these results are in B1:B100 try the following:
- select the range
- goto 'Format - conditional Format'
- enter the formula
=ISNA(B1)
- choose a white font as format
 
Back
Top