Specifications

App - 22
Function Description
Exp Exponential function
FileAttr Returns the file handle information of OS or the file mode.
FileDateTime Returns the character string indicating the file creation and updated date.
FileLen Returns the file length.
Filter
Returns the zero-base array including the subset of character string array based on the
designated filter conditions.
Fix Drops the fractional portion from a numerical value and returns only the integer portion.
Format,Format $ Returns a numerical value, date, time and character string according to a format.
FormatCurrency
Converts to the character string of currency format using the format defined in the [Control panel]
of system
FormatDateTime Returns the character string of date or time fomat.
FormatNumber Returns the character string of number format.
FormatPercent Adds a percent sign to the percent expression multiplied by 100 and returns it.
FreeFile Returns the next available file No.
FV
Pays a flat fee regularly and returns the future value of investment assuming that the interenst
rate is constant.
GetAllsettings Acquires the key setting value list from the entry of application in the registry of Windows.
GetAttr Returns the attributes of file, directory and volume label.
GetObject Acquires the OLE automation object.
GetSetting Acquires the key setting value list from the items of application in the registry of Windows.
Hex,Hex $ Returns the character string indicating a numerical value in hexadecimal.
Hour Returns the integral value for indicating an hour (0 to 23) from the serial value of date-time.
IIf Returns one of two arguments depending on the evaluation results of expression.
IMEStatus Acquires the current status of IME.
Input,Input $ Reads the character string with length designated from a sequential file and returns it.
InputB,InputB $ Reads the character string with length designated from a sequential file and returns it.
InputBox,InputBox $ Displays a prompt in the dialog box and returns the contents of text box.
InStr
Searches the designated character string from some string and returns the identified character
position.
InStrB
Searches the designated character string from some string and returns the identified byte
position.
InstrRev
Searches the designated character string from the reverse direction of some string and returns
the identified character position.
Int
Drops the fractional portion from a numerical value and returns the integer portion smaller than
it.
IPmt Returns the interest rate paid at the term designated in the investment period.
IRR Returns the internal profit rate for a series of regular cash flow.
IsArray Returns whether the variant argument is an array or not.
IsDate Returns whether the variant argument can be coverted to the date or not.
IsEmpty Returns whether the variant argument is the Empty value or not.
IsError Returns whether the variant argument is the error value or not.
IsMissing Returns whether the designated argument is passed or not.
IsNull Returns whether the variant value is the Null or not.
IsNumeric Returns whether the variant argument can be coverted to a numerical value or not.