ISERROR - #NAME?
 

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

ISERROR - #NAME?
 

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

--
Kind regards,

Niek Otten


"Mpaul" wrote in message
...
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

ISERROR - #NAME?
 

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

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten


"Mpaul" wrote in message
...
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