ISERROR - #NAME?

[Guest]

When I use a logical formula (i.e. If, etc.) and put ISERROR in the formula I
receive #NAME? in red. I know I am spelling it correctly and I've gone to
the Tools menu, options, calculation tab and "Accept labels in formulas " is
checked. What else could it be?

Thanks for any help!

M

 

[Niek Otten]

Please supply your formula and any input values. We're not clairvoyant!

 

[Guest]

I figured it out. I didn't have the name defined in the worksheet. Thanks.
MP