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.995732LOG(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)
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
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