Function looks ok to me, but am getting #NAME?

  • Thread starter Thread starter Colleyville Alan
  • Start date Start date
C

Colleyville Alan

I am working with a bond calculation worksheet and there is a formula for
yield that gives the #NAME? message in the cell. I looked at the values
that made up the formula and they seemed ok. I then tried copying the
example directly from the Excel help file, which is this:

YIELD("2/15/1999","11/15/2007",0.0575,95.04287,100,2,0)

Even then, I get #NAME? in the cell and not the 0.065 that I should get.
What gives?
 
Hi Alan!

A classic sign that you haven't got Analysis ToolPak installed and /
or selected.

If Analysis ToolPak is not installed or selected any cells containing
Analysis ToolPak functions and all dependent cells will return the
dreaded #NAME! If that happens read on. In any case, you should read
on if you are building an application that others might use especially
if used on different computers.

***Excel 2002 and 2003***

Use Tools > Add-Ins

Check the Analysis ToolPak entry.

If you get no messages, press OK.

Depending upon whether its been used before and upon load on first use
options used during installation, you may get messages requiring you
to insert the setup discs.

Once selected, Analysis ToolPak will be loaded every time Excel boots
up until it is de-selected as an Add-In. There is a small penalty in
terms of opening speed that varies from system to system depending
upon specification.

***Excel 2000 and before***

Use Tools > Add-Ins [For old specification computers it might take a
few seconds before anything happens!]

If there is an Analysis ToolPak entry in the Options listed just put a
check against it and press OK.

If there is not an Analysis ToolPak entry you will need to close Excel
and re-run the Setup discs. You will find that Analysis ToolPak is
listed as one of the options for Excel's installation.

Once that is done you may open Excel and you'll find that it is now
listed as an Add-In when you use Tools > Add-Ins.

Once selected, Analysis ToolPak will be loaded every time Excel boots
up until it is de-selected as an Add-In. There is a small penalty in
terms of opening speed that varies from system to system depending
upon specification.




--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Norman Harker said:
Hi Alan!

A classic sign that you haven't got Analysis ToolPak installed and /
or selected.
Click to expand...

I've read about that happening to other people, but I never gave it a second
thought. Thanks, it fixed my problem.
 
Back
Top