You're welcome!

--
Biff
Microsoft Excel MVP


"Alfred90210" wrote in message
...
THANK YOU!!!!!

"T. Valko" wrote:

You have to build that into the formula. Since you didn't post the
formula
you can try this general syntax:

=IF(ISERROR(your_formula),"N/A",your_formula)

That will trap *all* errors, not just the #DIV/0! error.

--
Biff
Microsoft Excel MVP


"Alfred90210" wrote in message
...
Isn't there an 'Excel Option' that allows you to enter value (Free
Text...
IE
N/A) when you get a #/div error?

I know that pivot tables have that option, but I'm not using a pivot
table
and I'd like to use that option. Thanks in advance!!