| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List of Financial functions
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List of Financial functions
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 -- Rick (MVP - Excel) "MrT" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List of Financial functions
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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ý. ;-) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List of Financial functions
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 (MVP - Excel) "Rick Rothstein" wrote in message ... 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 -- Rick (MVP - Excel) "MrT" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List of Financial functions
-- Rick (MVP - Excel) "Lars-Åke Aspelin" wrote in message ... 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? 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/ex...al%20functions into a blank Excel worksheet and then selected the items in Column A and copy/pasted them into my response. Rick |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List of Financial functions
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 "Rick Rothstein" wrote: 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 (MVP - Excel) "Rick Rothstein" wrote in message ... 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 -- Rick (MVP - Excel) "MrT" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| financial functions | Excel Discussion (Misc queries) | |||
| Financial functions | Excel Worksheet Functions | |||
| financial functions - HELP!!! | Excel Worksheet Functions | |||
| Financial functions | Excel Worksheet Functions | |||
| Financial Functions | Excel Worksheet Functions | |||
Linear Mode
