Math and Trig Formulas
Practice 26 Excel math and trigonometry formulas like SUM, SUMIFS, ROUND, PRODUCT, and MOD with interactive exercises. Perform calculations and solve complex numeric problems efficiently.
Abs Absolute Value Math Formula
Learn how to remove negative signs in Excel with ABS. Calculate budget variances, distance deviations, and audit tolerance thresholds cleanly.
Ceiling & Floor Multiple Rounding Formulas
Learn how to round numbers to custom multiples in Excel using CEILING and FLOOR. Round wholesale packs, billing intervals, and currency increments cleanly.
Int & Trunc Integer Math Formulas
Learn the critical difference between INT and TRUNC in Excel. Extract whole integers, strip time from timestamps, and handle negative numbers accurately.
Mod Modulo Remainder Math Formula
Learn the Excel MOD formula. Calculate division remainders, fix overnight shift hours crossing midnight, and build cyclic repeating schedules cleanly.
Pi Geometric Constant Formula
Learn trigonometry in Excel using PI, RADIANS, SIN, COS, and TAN. Convert degrees to radians and calculate structural heights and angles accurately.
Power & Sqrt Exponential Math Formulas
Learn how to calculate exponents, square roots, and nth roots in Excel with POWER and SQRT. Learn fractional powers and solve compound growth cleanly.
Product Mathematical Multiplication Formula
Learn how to multiply ranges of numbers in Excel with PRODUCT. Safely ignore text labels, calculate compound growth factors, and compute volume cleanly.
Rand & Randbetween Random Number Formulas
Generate unbiased test datasets, audit sample selections, and Monte Carlo numbers using Excel RAND and RANDBETWEEN. Learn how to freeze volatile values cleanly.
Round, Roundup & Rounddown Formulas
Eliminate 1-cent reconciliation discrepancies in Excel with ROUND, ROUNDUP, and ROUNDDOWN. Control decimal places and round to powers of ten cleanly.
Sin, Cos & Tan Trigonometric Formulas
Learn forward and inverse trigonometry in Excel with SIN, COS, TAN, ASIN, ACOS, and ATAN. Learn radian conversion and solve geometric slopes accurately.
Subtotal Dynamic Filtered Formula
Learn the Excel SUBTOTAL formula. Calculate sums, averages, and counts on visible filtered rows while preventing accidental double-counting automatically.
Sum Addition Foundation Formula
Learn the Excel SUM formula. Safely add continuous ranges, avoid the silent text trap, sum across multiple columns, and use the Alt + = AutoSum shortcut.
Sumif & Sumifs Conditional Addition Formulas
Learn conditional addition in Excel with SUMIF and SUMIFS. Filter revenue by region, apply date criteria, use wildcards, and Learn the reversed syntax order.
Sumproduct Array Multiplication Formula
Learn the Excel SUMPRODUCT formula. Multiply arrays, calculate weighted averages, and evaluate multi-condition logic without helper columns.
Math and trigonometric formulas are the foundational building blocks of numerical modeling. Learn rounding precision rules with ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING.MATH, and FLOOR.MATH.
Harness conditional arithmetic and weighted calculations using SUMIFS, PRODUCT, SUMPRODUCT, MOD, TRUNC, and SUBTOTAL for filtered list analysis.