Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|