Numeric Functions

ABS(x)

This function returns the absolute (positive) value of a number. Example: ABS(-10)=10

CEILING(x)

This function returns the smallest integer value that is bigger than or equal to a number. Example: CEILING (-10.5)=-10

EXP(x)

This function returns e raised to the power of the specified number.

FLOOR(x)

This function returns the largest integer value that is smaller than or equal to a number. Example: FLOOR(0.5)=0

LOG(x) or LOG(base,x)

This function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base. Example: LOG(20)=2.995732 LOG(20,10)=1.30103

MOD(x,y)

This function returns the remainder of a number divided by another number. Example: MOD(18, 4) returns the remainder of 18/4 = 2

POWER(x,y)

This function returns the value of a number raised to the power of another number. Example: POWER(4, 2) returns 4 raised to the second power (16)

ROUND(x,y)

This function rounds a number to a specified number of decimal places. Example: To round the number to 2 decimal places: ROUND(135.375, 2)=135.38

SQRT(x)

This function returns the square root of a number. Example: SQRT(16)=4

TRUNCATE(x,y)

This function truncates a number to the specified number of decimal places. Example: TRUNCATE(138.375, 2) = 138.37