I have activated the 'Analysis Toolpak' add -in, but many financial functions
are still not available - such as nominal and effective formula conversions.

The EFFECT() and NOMINAL() functions should be available. Did you put a checkmark near Analysis Toolpak in the ToolsAdd-ins
dialog?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darrell" wrote in message ...
|I have activated the 'Analysis Toolpak' add -in, but many financial functions
| are still not available - such as nominal and effective formula conversions.

I put the checkmark, but the functions are not working. I have been throught
this process on a number of other computers with no problem. Any ideas?

"Niek Otten" wrote:

The EFFECT() and NOMINAL() functions should be available. Did you put a checkmark near Analysis Toolpak in the ToolsAdd-ins
dialog?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darrell" wrote in message ...
|I have activated the 'Analysis Toolpak' add -in, but many financial functions
| are still not available - such as nominal and effective formula conversions.

<are not working

How do you see that?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darrell" wrote in message ...
|I put the checkmark, but the functions are not working. I have been throught
| this process on a number of other computers with no problem. Any ideas?
|
| "Niek Otten" wrote:
|
| The EFFECT() and NOMINAL() functions should be available. Did you put a checkmark near Analysis Toolpak in the ToolsAdd-ins
| dialog?
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Darrell" wrote in message ...
| |I have activated the 'Analysis Toolpak' add -in, but many financial functions
| | are still not available - such as nominal and effective formula conversions.
|
|
|

If I 'insert function' and select 'financial' from the drop-down menu, the
'nominal' and 'effect' formulas are not amongst the options. Also, if I open
a spreadsheet with a 'nominal' or 'effect' formula, it does not display the
result, but gives a #name error in the cell.

"Niek Otten" wrote:

<are not working

How do you see that?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darrell" wrote in message ...
|I put the checkmark, but the functions are not working. I have been throught
| this process on a number of other computers with no problem. Any ideas?
|
| "Niek Otten" wrote:
|
| The EFFECT() and NOMINAL() functions should be available. Did you put a checkmark near Analysis Toolpak in the ToolsAdd-ins
| dialog?
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Darrell" wrote in message ...
| |I have activated the 'Analysis Toolpak' add -in, but many financial functions
| | are still not available - such as nominal and effective formula conversions.
|
|
|

If you get the #NAME error Excel doesn't recognize the function. Therefore,
the Analysis Toolpak hasn't been installed, even if you think you went
through the process. Do you have the original installation CDs? Try
installing from there or else contact your IT department.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Darrell" wrote:

If I 'insert function' and select 'financial' from the drop-down menu, the
'nominal' and 'effect' formulas are not amongst the options. Also, if I open
a spreadsheet with a 'nominal' or 'effect' formula, it does not display the
result, but gives a #name error in the cell.

"Niek Otten" wrote:

<are not working

How do you see that?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darrell" wrote in message ...
|I put the checkmark, but the functions are not working. I have been throught
| this process on a number of other computers with no problem. Any ideas?
|
| "Niek Otten" wrote:
|
| The EFFECT() and NOMINAL() functions should be available. Did you put a checkmark near Analysis Toolpak in the ToolsAdd-ins
| dialog?
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Darrell" wrote in message ...
| |I have activated the 'Analysis Toolpak' add -in, but many financial functions
| | are still not available - such as nominal and effective formula conversions.
|
|
|

There is a bug in that the Add-in doesn't always load:
http://support.microsoft.com/kb/291058/EN-US/
--
David Biddulph

"Darrell" wrote in message
...
If I 'insert function' and select 'financial' from the drop-down menu, the
'nominal' and 'effect' formulas are not amongst the options. Also, if I
open
a spreadsheet with a 'nominal' or 'effect' formula, it does not display
the
result, but gives a #name error in the cell.

"Niek Otten" wrote:

<are not working

How do you see that?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darrell" wrote in message
...
|I put the checkmark, but the functions are not working. I have been
throught
| this process on a number of other computers with no problem. Any ideas?
|
| "Niek Otten" wrote:
|
| The EFFECT() and NOMINAL() functions should be available. Did you put
a checkmark near Analysis Toolpak in the ToolsAdd-ins
| dialog?
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Darrell" wrote in message
...
| |I have activated the 'Analysis Toolpak' add -in, but many financial
functions
| | are still not available - such as nominal and effective formula
conversions.
|
|
|