View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default List of Financial functions

On Sat, 24 Jan 2009 19:19:11 GMT, Lars-Åke Aspelin
wrote:

On Sat, 24 Jan 2009 13:32:25 -0500, "Rick Rothstein"
wrote:

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


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