User defined functions that are installed with add-ins
If add-ins that you install contain functions, these add-in or automation functions will be available in the User Defined category in the Insert Function dialog box.Note User-defined functions (UDFs) are not available in Excel Web App.
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 |
Post a Comment
Blogger FacebookYour Comment Will be Show after Approval , Thanks