Changing #NUM! for a blank cell

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
 
G

Gord Dibben

That will mask all errors.

Might not be what you want.


Gord Dibben MS Excel MVP
 
Top