Archive

ROUND

Rounds a number to the specified number of digits.

RANDBETWEEN

Returns a random number in the range between two numbers you specify.

RAND

Returns a random number greater than or equal to 0 and less than 1, evenly distributed. The number that is returned changes each time the cell containing this function is recalculated.

RADIANS

Converts degrees to radians.

QUOTIENT

Performs division and returns only the integer portion of the division result. Use this function when you want to discard the remainder of division.

PRODUCTX

Returns the product of an expression evaluated for each row in a table.

PRODUCT

Returns the product of the numbers in a column.

POWER

Returns the result of a number raised to a power.

PI

Returns the value of Pi, 3.14159265358979, accurate to 15 digits.

ODD

Returns number rounded up to the nearest odd integer.