Excel function category
Excel Math and Trig Functions
Reference pages for common math formulas used in totals, rounding, conditional calculations, and everyday numeric worksheet logic.
7 functions
MOD
Math & Trig
Return the remainder after a number is divided by a divisor.
Syntax
MOD(number, divisor)Used in 8 articlesView reference
ROUND
Math & Trig
Round a number to a specified number of digits.
Syntax
ROUND(number, num_digits)Used in 3 articlesView reference
ROUNDUP
Math & Trig
Round a number up, away from zero, to a specified number of digits.
Syntax
ROUNDUP(number, num_digits)Used in 1 articleView reference
SUM
Math & Trig
Add numbers, cell references, and ranges together in a single formula.
Syntax
SUM(number1, [number2], ...)Used in 15 articlesView reference
SUMIF
Math & Trig
Add values that meet a single condition.
Syntax
SUMIF(range, criteria, [sum_range])Used in 2 articlesView reference
SUMIFS
Math & Trig
Add values that meet multiple conditions at the same time.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ...)Used in 9 articlesView reference
TRUNC
Math & Trig
Truncate a number by removing digits without rounding the result.
Syntax
TRUNC(number, [num_digits])Used in 3 articlesView reference