List of Financial functions

[MrT]

Hi,
I would like to create a list box in a form that lists all math functions of
Excel. Is there a way I can easily re-use the list that is displayed when you
use Insert / Function / Math ... ?

Thanks,

MrT

 

[Rick Rothstein]

Is this the list you are looking for?

ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COMBIN
COS
COSH
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR
GCD
INT
LCM
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC

 

[Lars-Åke Aspelin]

Is this the list you are looking for?

ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COMBIN
COS
COSH
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR
GCD
INT
LCM
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC

Those are the methods/function in the "Math & Trig" category.
But the OP wanted the methods/function in the "Financial" category.
Is it possible to get the list programmatically out of the
WorksheetFunction object?

Lars-Åke

 

[Lars-Åke Aspelin]

Those are the methods/function in the "Math & Trig" category.
But the OP wanted the methods/function in the "Financial" category.
Is it possible to get the list programmatically out of the
WorksheetFunction object?

Lars-Åke

Maybe I looked to much on the subject line and to little at the
message bodý. ;-)

 

[Rick Rothstein]

It was pointed out elsewhere in this thread that you are probably looking
for a list of the Financial functions. Here is that list...

ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
FV
FVSCHEDULE
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT

 

[Rick Rothstein]

--
Rick (MVP - Excel)

Those are the methods/function in the "Math & Trig" category.
But the OP wanted the methods/function in the "Financial" category.
Is it possible to get the list programmatically out of the
WorksheetFunction object?

Ah, I see... his subject line say "Financial functions". I responded to his
message's text when he said "that lists all math functions " coupled with
his statement "when you use Insert / Function / Math".

I simply copy/pasted the appropriate section from this website...

http://office.microsoft.com/en-us/excel/HP052042111033.aspx#Financial functions

into a blank Excel worksheet and then selected the items in Column A and
copy/pasted them into my response.

Rick

 

[MrT]

Actually, I don't mind if financial or maths (sorry for the confusion). The
question, is can I access that programmatically, as I need to add potentially
other user defined functions. I don't want to have a list hardcoded.

Thanks,

MrT