Math & Trig Functions
Master 26 Excel math and trigonometry functions like SUM, SUMIFS, ROUND, PRODUCT, and MOD with interactive exercises. Perform calculations and solve complex numeric problems efficiently.
Instant Feedback
Live Answer Checking
Industry Datasets
Math & Trig Functions Foundations
Learn how Excel math and trig functions handle rounding, signs, remainders, and basic numeric calculations.
Abs Function
Returns the absolute value of a number. ABS is useful when the magnitude of a result matters more than its direction, such as variance analysis, tolerance checks, and distance calculations.
Ceiling.math Function
Rounds a number up to the nearest integer or specified multiple.
Floor.math Function
Rounds a number down to the nearest integer or specified multiple.
Int Function
Rounds a number down to the nearest integer. INT is useful when you need the mathematical floor of a value, remove the time portion from a datetime, or keep only complete units from a division result.
Mdeterm Function
Calculate the matrix determinant of an array in Excel using MDETERM. Master system of linear equations with interactive spreadsheet exercises.
Minverse Function
Calculate the inverse matrix of a square array in Excel using MINVERSE. Solve advanced matrix mathematics through hands-on practice lessons.
Mmult Function
Calculate matrix product of two arrays in Excel using the MMULT function. Practice linear algebra and multivariate spreadsheet calculations.
Mod Function
Returns the remainder after division. MOD is useful for divisibility tests, repeating cycles, alternating-row logic, and time calculations that wrap across midnight.
Mround Function
Rounds a number to the nearest specified multiple.
Munit Function
Returns the identity matrix for a chosen dimension.
Pi Function
Returns the mathematical constant pi. PI is used in circle formulas, radian-based trigonometry, and geometry calculations that depend on circular relationships.
Power Function
Raise numbers to any mathematical power or exponent in Excel using the POWER function. Master compounding growth formulas with live exercises.
Product Function
Multiplies numbers, references, and ranges in one formula. PRODUCT is useful when a model depends on compounded factors rather than additive totals.
Rand Function
Returns a random decimal greater than or equal to 0 and less than 1. RAND is useful for simulation models, random sampling, and generating test values that recalculate automatically.
Randbetween Function
Returns a random integer between two specified bounds. RANDBETWEEN is useful for discrete simulations, test datasets, and randomized indexing.
Round Function
Round numbers to a specified number of digits in Excel using the standard ROUND function. Practice financial precision and formatting rules.
Rounddown Function
Round numeric values down towards zero in Excel using ROUNDDOWN. Practice currency truncation, tax rules, and precision controls in live worksheets.
Roundup Function
Round numbers up away from zero in Excel using the ROUNDUP function. Practice packaging calculations, fee estimates, and precision control.
Sin Function
Returns the sine of an angle expressed in radians. SIN is used in trigonometry, coordinate geometry, waveform modeling, and component calculations.
Sqrt Function
Returns the positive square root of a number. SQRT is commonly used in geometry, distance formulas, and statistical models that depend on the principal square root.
Subtotal Function
Performs a calculation such as SUM or AVERAGE while respecting filtered rows.
Sum Function
Adds numbers, cell references, and ranges in a single formula. SUM is the standard aggregation function for totals, running balances, and cross-sheet consolidation.
Sumif Function
Sums values that meet one condition. SUMIF is used for category totals, threshold-based aggregation, and dynamic single-criteria reports.
Sumifs Function
Sums values that satisfy multiple conditions. SUMIFS is used for AND-based aggregation across several fields such as product, region, date, or threshold.
Sumproduct Function
Multiplies arrays element by element, then sums the results.
Trunc Function
Removes digits from a number by truncation, without rounding.
Math and trigonometric functions are the foundational building blocks of numerical modeling. Master 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.