removing the #N/A error

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
 
A

A.W.J. Ales

Blueshot

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

--
Regards,
Auk Ales

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

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

#DIV error 2
Removing #N/A from an "If/Then" statement 4
Drop down list control value in vba 2
Same forumula returns both 0 & N/A 2
Use & with two formulas 2
Find #N/A in column D 2
runtime error 9 subscript out of range 1
Count Number of Unique Cells That Don't Have Certain Characters 0

Top