Changing #NUM! for a blank cell

  • Thread starter Thread starter Byron720
  • Start date Start date
B

Byron720

I have a formula that works fine except that when the result is false, it
gives me a #NUM!. How do I change that (maybe an IF or something) so that
everytime I get #NUM! it automatically changes to a blank cell.

PS: My current formula is an array formula
 
Problem solved: I added IF with ISERROR to the formula and I worked fine.
 
That will mask all errors.

Might not be what you want.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

#num 3
num! 1
Conditional Formating 3
#num fix 1
NUM Error 1
#Num! appears at the end of correct entries 3
Creating a MyIsEven function 7
Conditional Format for > 3 Text possibilities 3

Back
Top