| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List of functions contained in the add-ins, esp. Analysis Toolpak
Does anyone know where to get a list of all the functions contained in the
add-ins, especially the Analysis Toolpak and VBA Analysis Toolpak. I've looked in Excel help and have found a list of functions by category, but no summary of which ones appear in those toolpaks. If anyone knows of a helpfile / website / whatever that provides a simple list detailing which functions require which add-ins to be installed it would really help me. Many thanks in advance, Neil |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List of functions contained in the add-ins, esp. Analysis Toolpak
http://www.xlfdic.com/
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Neil Goldwasser" wrote in message ... Does anyone know where to get a list of all the functions contained in the add-ins, especially the Analysis Toolpak and VBA Analysis Toolpak. I've looked in Excel help and have found a list of functions by category, but no summary of which ones appear in those toolpaks. If anyone knows of a helpfile / website / whatever that provides a simple list detailing which functions require which add-ins to be installed it would really help me. Many thanks in advance, Neil |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List of functions contained in the add-ins, esp. Analysis Toolpak
Here is what I just pulled out of the ATPVBAEN.xla module (xl 2002).
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware Function Bin2Hex Function Bin2Oct Function Bin2Dec Function Dec2Bin Function Dec2Oct Function Dec2Hex Function Hex2Bin Function Hex2Dec Function Hex2Oct Function Oct2Dec Function Oct2Bin Function Oct2Hex Engineering functions Function Erf Function Erfc Function Factdouble Function IsOdd Function IsEven Function SqrtPI Function Quotient Function MRound Function Delta Function GeStep Function BesselI Function BesselJ Function BesselY Function BesselK Function Convert Complex functions Function ImSub Function ImDiv Function ImConjugate Function ImSin Function ImCos Function ImExp Function ImLog10 Function ImLog2 Function ImLn Function ImSqrt Function ImAbs Function ImArgument Function ImReal Function Imaginary Function ImPower Function Complex Functions with 1..29 arguments Function SeriesSum Function ImSum Function ImProduct Function Lcm Function Gcd Function Multinomial Date manipulation functions Function Weeknum Function EoMonth Function Workday Financial date functions Function Edate Function Coupdaybs Function Coupdays Function Coupdaysnc Function Coupncd Function Coupnum Function Couppcd Function FvSchedule Function XNpv Function XIrr Add-in functions Function Randbetween Function IsShared French financial functions Function Amorlinc Function Amordegrc Function Effect Function Nominal Function Dollarde Function Dollarfr Function Accrint Function Accrintm Function Price Function Yield Function Pricemat Function Yieldmat Function Pricedisc Function Yielddisc Function Disc Function Received Function Intrate Function Tbillprice Function Tbillyield Function Tbilleq Function Duration Function MDuration Function OddFPrice Function OddFYield Function OddLPrice Function OddLYield '---------------------------- "Neil Goldwasser" wrote in message Does anyone know where to get a list of all the functions contained in the add-ins, especially the Analysis Toolpak and VBA Analysis Toolpak. I've looked in Excel help and have found a list of functions by category, but no summary of which ones appear in those toolpaks. If anyone knows of a helpfile / website / whatever that provides a simple list detailing which functions require which add-ins to be installed it would really help me. Many thanks in advance, Neil |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List of functions contained in the add-ins, esp. Analysis Tool
Many thanks for your help Bob and Jim, it is much appreciated.
Cheers, Neil "Jim Cone" wrote: Here is what I just pulled out of the ATPVBAEN.xla module (xl 2002). -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware Function Bin2Hex Function Bin2Oct Function Bin2Dec Function Dec2Bin Function Dec2Oct Function Dec2Hex Function Hex2Bin Function Hex2Dec Function Hex2Oct Function Oct2Dec Function Oct2Bin Function Oct2Hex Engineering functions Function Erf Function Erfc Function Factdouble Function IsOdd Function IsEven Function SqrtPI Function Quotient Function MRound Function Delta Function GeStep Function BesselI Function BesselJ Function BesselY Function BesselK Function Convert Complex functions Function ImSub Function ImDiv Function ImConjugate Function ImSin Function ImCos Function ImExp Function ImLog10 Function ImLog2 Function ImLn Function ImSqrt Function ImAbs Function ImArgument Function ImReal Function Imaginary Function ImPower Function Complex Functions with 1..29 arguments Function SeriesSum Function ImSum Function ImProduct Function Lcm Function Gcd Function Multinomial Date manipulation functions Function Weeknum Function EoMonth Function Workday Financial date functions Function Edate Function Coupdaybs Function Coupdays Function Coupdaysnc Function Coupncd Function Coupnum Function Couppcd Function FvSchedule Function XNpv Function XIrr Add-in functions Function Randbetween Function IsShared French financial functions Function Amorlinc Function Amordegrc Function Effect Function Nominal Function Dollarde Function Dollarfr Function Accrint Function Accrintm Function Price Function Yield Function Pricemat Function Yieldmat Function Pricedisc Function Yielddisc Function Disc Function Received Function Intrate Function Tbillprice Function Tbillyield Function Tbilleq Function Duration Function MDuration Function OddFPrice Function OddFYield Function OddLPrice Function OddLYield '---------------------------- "Neil Goldwasser" wrote in message Does anyone know where to get a list of all the functions contained in the add-ins, especially the Analysis Toolpak and VBA Analysis Toolpak. I've looked in Excel help and have found a list of functions by category, but no summary of which ones appear in those toolpaks. If anyone knows of a helpfile / website / whatever that provides a simple list detailing which functions require which add-ins to be installed it would really help me. Many thanks in advance, Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't install Analysis ToolPak for Office XP | Setting up and Configuration of Excel | |||
| data analysis toolpak | Excel Discussion (Misc queries) | |||
| analysis toolpak | Excel Discussion (Misc queries) | |||
| analysis toolpak | Excel Discussion (Misc queries) | |||
| Why can't I see Analysis Toolpak functions when I have loaded it . | Excel Worksheet Functions | |||
Linear Mode
