Functions

A built-in function can be used to manipulate data or to perform specific calculations.
If you cannot find the appropriate built-in function, then you can write your own Functions and Subroutines.

Complete List

This Complete List of Functions provides details and examples for all the functions and statements.

Categories

Arrays	These are used for creating, analysing and filtering arrays.
Data Types	These are used for converting from one data type to another.
Dates & Times	These are used for entering and calculating dates and times.
Files & Directories	These are used for opening and closing files and directories.
Financial	These are used for depreciation, accrued interest, annuities and rates of return.
Input & Output	These are used for reading and writing data to and from files.
Numbers	These are used for maths, trigonometry and logarithms.
Objects	These are used for loading and unloading ActiveX or OLE objects.
Registry	These are used for reading, writing and removing values in the registry.
Strings & Characters	These are used for searching, replacing and manipulating text.
Other	These are used for all the functions that do not fall into one of the above categories.

Arrays These are used for creating, analysing and filtering arrays.
Data Types These are used for converting from one data type to another.
Dates & Times These are used for entering and calculating dates and times.
Files & Directories These are used for opening and closing files and directories.
Financial These are used for depreciation, accrued interest, annuities and rates of return.
Input & Output These are used for reading and writing data to and from files.
Numbers These are used for maths, trigonometry and logarithms.
Objects These are used for loading and unloading ActiveX or OLE objects.
Registry These are used for reading, writing and removing values in the registry.
Strings & Characters These are used for searching, replacing and manipulating text.
Other These are used for all the functions that do not fall into one of the above categories.