Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a formula in excel and it is bring up the result of #NAME? how do
I produce the result as blank
 
#NAME indicates an error in the formula - what is your formula?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If sign of sum is negative change to positive 1
result should equal a blank field 2
SUMIF with criteria "<>" & "=" 4
Set the Length of the Cell 1
Using text as data? 0
Nested functions using array/range names 3
Excel help separating / 2
Lookup Formula 4

Back
Top