∑ Math & Trig

Crunch the numbers. From simple aggregation to conditional summing, rounding, and random simulation.

The first formula everyone learns. Add up a range of numbers instantly.

02. SUMIF / SUMIFS

Add numbers only if they meet specific criteria (e.g., "Total Sales for Apples").

Multiply all numbers in a range. Useful for compounding growth or volume calculations.

04. QUOTIENT / MOD

Divide numbers and handle the pieces. Get the integer result (Quotient) or just the Remainder (Mod).

05. POWER / SQRT

Exponents and Roots. Calculate squares, cubes, and square roots.

Control your decimals. ROUND (Nearest), ROUNDUP (Always away from 0), and ROUNDDOWN (Towards 0).

07. CEILING / FLOOR

Round to a specific multiple (Significance). E.g., Round price up to the nearest $0.99 or $5.00.

Strip the decimals. Converts any decimal number down to the nearest integer.

Absolute Value. Removes the negative sign (e.g., -50 becomes 50). Useful for variance checks.

🎲 Simulation

10. RAND / RANDBETWEEN

Generate random data. Create decimals between 0-1 or integers between specific limits.

⬅ Back to Excel Menu