removing the #N/A error

  • Thread starter Thread starter blueshot
  • Start date Start date
B

blueshot

I have a formula that often results in #N/A depending on the data use
to calculate the result (for example 0/0).

Can you tell my how I can make this cell show blank if the erro
occrus. If the result of the formula is legitimate, then obviously
want it to show.

Thanks,
Bluesho
 
Blueshot

Use =If(Iserror(Formula),"",Formula)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top