Changing #NUM! for a blank cell

[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

 

[Byron720]

Problem solved: I added IF with ISERROR to the formula and I worked fine.

 

[T. Valko]

See my reply in your other post

 

[Gord Dibben]

That will mask all errors.

Might not be what you want.


Gord Dibben MS Excel MVP