User defined functions that are installed with add-ins (reference)
If add-ins that you install contain functions, these add-in and automation functions will be available in the User Defined category in the Insert Function dialog box.
Note: User defined functions (UDFs) aren't available in Excel Online.
To get detailed information about a function, click its name in the first column.
Function | Description |
Calls a procedure in a dynamic link library or code resource | |
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 an intermediary (triangulation) | |
Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered | |
Connects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programming |
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
No comments:
Post a Comment