Wednesday, January 3, 2018

User defined functions that are installed with add-ins (reference)

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

CALL function

Calls a procedure in a dynamic link library or code resource

EUROCONVERT function

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)

REGISTER.ID function

Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered

SQL.REQUEST function

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.

See Also

Excel functions (by category)

Excel functions (alphabetical)

No comments:

Post a Comment