Numbers Functions

ABSReturns the absolute value of a number (Variant).
ATNReturns the arc-tangent of a number in radians (Double).
COSReturns the cosine of an angle in radians (Double).
EXPReturns the base of natural logarithm raised to a power (Double).
FIXReturns the integer portion of a number (Double).
FORMATCURRENCYReturns the expression formatted as a currency value (String).
FORMATNUMBERReturns the expression formatted as a number (String).
FORMATPERCENTReturns the expression formatted as a percentage (String).
HEXReturns the number converted to hexadecimal (String).
INTReturns the number rounded down to the nearest integer (Double).
LOGReturns the natural logarithm of a number (Double).
OCTReturns the number converted to octal (Variant).
RANDOMIZEInitialises the random number generator.
RNDReturns a random number between 0 and 1 (Single).
ROUNDReturns a number rounded to a given number of decimal places (Double).
SGNReturns the sign of a number (Integer).
SINReturns the sine of an angle in radians (Double).
SQRReturns the square root of a number (Double).
TANReturns the tangent of an angle (Double).
ABS
Returns the absolute value of a number (Variant).
ATN
Returns the arc-tangent of a number in radians (Double).
COS
Returns the cosine of an angle in radians (Double).
EXP
Returns the base of natural logarithm raised to a power (Double).
FIX
Returns the integer portion of a number (Double).
FORMATCURRENCY
Returns the expression formatted as a currency value (String).
FORMATNUMBER
Returns the expression formatted as a number (String).
FORMATPERCENT
Returns the expression formatted as a percentage (String).
HEX
Returns the number converted to hexadecimal (String).
INT
Returns the number rounded down to the nearest integer (Double).
LOG
Returns the natural logarithm of a number (Double).
OCT
Returns the number converted to octal (Variant).
RANDOMIZE
Initialises the random number generator.
RND
Returns a random number between 0 and 1 (Single).
ROUND
Returns a number rounded to a given number of decimal places (Double).
SGN
Returns the sign of a number (Integer).
SIN
Returns the sine of an angle in radians (Double).
SQR
Returns the square root of a number (Double).
TAN
Returns the tangent of an angle (Double).

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top