Name

F

Freddo

I am doing a formula in excel and it is bring up the result of #NAME? how do
I produce the result as blank
 
D

David Biddulph

Freddo said:
I am doing a formula in excel and it is bring up the result of #NAME? how
do
I produce the result as blank
Click to expand...

You could use =IF(ISERROR(your formula),"",your formula)
but a result of #NAME? implies that your formula is wrong.
 
D

Dave H

Freddo said:
I am doing a formula in excel and it is bring up the result of #NAME
how do
I produce the result as blank
Click to expand...
If you are ok with the fact that the name specified wasn't found the
you could use =if(iserror( your formula ),"", your formula
 
C

Chip Pearson

You get a NAME error when your formula has a misnamed function or
is attempting to use a defined name that does not exist. If the
function you are using is part of the Analysis ToolPak, you'll
need to load that add-in. Go to the Tools menu, choose Add-Ins,
and put a check next to Analysis ToolPak.

You should post here the formula that is giving you the error.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top