Scribd
Upload
5 views2 pages

Essential Numeric Functions Explained

Uploaded by

worktest1155
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

Essential Numeric Functions Explained

Uploaded by

worktest1155
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Numeric Functions

ABS(): Returns the absolute value of a number.

CEIL(), CEILING(): Returns the smallest integer value greater than or equal to a number.

FLOOR(): Returns the largest integer value less than or equal to a number.

ROUND(): Rounds a number to a specified number of decimal places.

TRUNCATE(): Truncates a number to a specified number of decimal places.

SIGN(): Returns the sign of a number 1, 0, or 1 .

POWER(), POW(): Raises a number to the power of another number.

SQRT(): Returns the square root of a number.

PI(): Returns the value of pi (π).

MOD(): Returns the remainder of a division operation.


Numeric Functions

RAND(): Returns a random floating-point value between 0 and 1.

GREATEST(): Returns the greatest value from a list of values.

LEAST(): Returns the smallest value from a list of values.

You might also like