Nominal function in vb

GuillaumeJ

New Member
Joined
Mar 10, 2004
Messages
27
Hi everyone,

I would like to use the NOMINAL function (included in the Analysis vb toolpack) in one of my macros. Is there a way to have it available in vba ?

Thank you for your help
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
In case it isn't available in VBA, you could use the formulas:
Effective Rate, or APY:
APY = (1+%rate/# of periods/yr)^(# of periods/yr) - 1
Nominal rate, or rate:
Rate =((1+%APY)^(1/# of periods/yr) - 1)*(# of periods/yr)
 

GuillaumeJ

New Member
Joined
Mar 10, 2004
Messages
27
Yes, it's what I did actually but I was wondering how (or if) it is possible to get access in the VBA code to the worksheet functions included in addins, such as the analysis toolpack.
 

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
I'm sorry that I cannot help you in VBA, but, I feel that someone else, who can, will pick this up. Good luck!
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
In the VBA Editor goto Tools>References... and check atvbaen.xls.

You should then be able to use Nomimal in VBA.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,014
Members
412,304
Latest member
citrus
Top