Number Functions

ABSReturns the absolute value of a number (Variant).
ATNReturns the arctangent 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 (Integer).
FORMATReturns the text string of a number or date in a particular format (String).
HEXReturns the number converted to hexadecimal (String).
INTReturns the number rounded down to the nearest integer (Integer).
ISNUMERICReturns the value indicating if an expression contains a number (Boolean).
LOGReturns the natural logarithm of a number (Double).
MODReturns the remainder after division (Integer).
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 arctangent 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 (Integer).
FORMAT
Returns the text string of a number or date in a particular format (String).
HEX
Returns the number converted to hexadecimal (String).
INT
Returns the number rounded down to the nearest integer (Integer).
ISNUMERIC
Returns the value indicating if an expression contains a number (Boolean).
LOG
Returns the natural logarithm of a number (Double).
MOD
Returns the remainder after division (Integer).
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).

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext