Function

Description

ABS

Returns the absolute value of a number

EVEN

Rounds a number up to the nearest even integer

FACT

Returns the factorial of a number

GCD

Returns the greatest common divisor

LCM

Returns the least common multiple

ODD

Rounds a number up to the nearest odd integer

PI

Returns the value of pi

POWER

Returns the result of a number raised to a power

PRODUCT

Multiplies its arguments

QUOTIENT

Returns the integer portion of a division

SIGN

Returns the sign of a number

SQRT

Returns a positive square root

SUM

Adds its arguments

SUMIF

Adds the cells specified by a given criteria