Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
Add-In and Automation Functions
Function |
Description |
Syntax |
||
CALL |
Calls a procedure in a dynamic link library or code resource |
(register_id,argument1,...)
or
(module_text,procedure,
type_text,argument1,...)
or
(file_text,resource,type_text,argument1,...) |
||
EUROCONVERT |
Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to
another by using the euro as
a triangulation |
(number,source,target,
full_precision,
triangulation_precision) |
||
GETPIVOTDATA |
Returns data stored in a
PivotTable report; can be used to retrieve summary data from a PivotTable report as long as the summary data is visible in the report |
(data_field,pivot_table,field1,
item1,field2,item2,...) |
||
REGISTER.ID |
Returns the register ID of the specific dynamic link library (DLL) or code resource that
has been previously registered; if the DLL or code resource has not been registered, REGISTER.ID registers the DLL or code resource and then returns the register ID |
(module_text,procedure,
type_text)
or
(file_text,resource,type_text) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag





