Math & Trig Functions |
Description |
---|---|
ABS | Returns the absolute value of a number. |
AGGREGATE | Returns one of many different aggregates from a list or database |
Rounding Functions | |
CEILING.MATH | Returns a Number Rounded away from Zero to the Nearest Multiple of significance |
FLOOR.MATH | Rounds a number down toward zero to the nearest multiple of significance |
INT | Rounds a number down to the nearest integer |
EVEN | Rounds a decimal number away from zero to the nearest even integer |
ODD | Rounds a decimal number away from zero to the nearest odd integer |
ROUND | Rounds a number to a specified number of digits |
ROUNDDOWN | Always rounds a number down |
ROUNDUP | Always rounds a number up |
MROUND | Rounds a value to a desired multiple |
TRUNC | Truncates a number by removing some or all of the decimal portion of a number |
MOD | Returns the remainder of a division problem |
GCD | Greatest Common Divisior (Returns the greatest common divisor of two or more integers) |
LCM | Least Common Multiple (Returns the least common multiple of integers) |
POWER | Returns the result of a number raised to a power |
RANDBETWEEN | Generates a Random number between two specified numbers |
SIGN | Determines the sign of a number then returns a 1 if the number is positive, a zero (0) if the number is 0 and a -1 if the number is negative |
SUMSQ | Returns the Sum of the Squares |
PRODUCT | Multiplies all of the numbers given for arguments |
SUMPRODUCT | Returns the sum of the multiplications of values in corresponding ranges |
SQRT | Returns the square root of a number |
SUBTOTAL | Returns the subtotal of the numbers in a column from a list or database |
SUM | Sums a series of values |
SUMIF | Used to sum values provided that they meet a condition that you specify |
SUMIFS | Used to sum values only if multiple conditions are met |