Return Cell to Blank Value

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

When putting in a formula say
IF(ISERROR(b2/c2),"",(b2/c2))

if there is an error the cell value is seen as blank but
when plotting the data to graph shows up as zero.

What I require is that the cell is left unformatted so
when plotting this data onto a graph it will not appare as
a data point.

Is there another way to do this?
 
Hi
try
IF(ISERROR(b2/c2),NA(),(b2/c2))

after this you may use conditional format to hide these
errors with a white font
 
Jim,

when there's a formula in the cell, Excel interprets the
blank as a value of zero. To leave blanks in your graph,
you have to force the cell value to #N/A, so amend your
formula to:

=IF(ISERROR(b2/c2),na(),b2/c2)

Admittedly, this will leave the actual data looking a bit
of a dog's breakfast but, if that bothers you or you need
to present the table too, use conditional formatting to
hide the #N/As.

Cheers, Pete.
 
Back
Top