MMULT Function in Excel: Multiply Matrices
MMULT multiplies two matrices. In practice it computes many weighted sums at once — quantities × price lists for many orders.
Read article →Math & Trig
Excel Math & Trig functions explained with syntax, examples and common mistakes.
SEQUENCE Function in Excel: Generate a List of Numbers or Dates
SEQUENCE Function in Excel: Generate a List of Numbers or Dates
SEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.
Read article →DECIMAL Function in Excel: Any Base Back to a Number
DECIMAL Function in Excel: Any Base Back to a Number
EngineeringLevel: IntermediateAvailable in: Excel 2013+DECIMAL reverses BASE.Syntax=DECIMAL(text, radix)ArgumentWhat it meansradix2 to 36.ExamplesExample.
Read article →BASE Function in Excel: Number in Any Base
BASE Function in Excel: Number in Any Base
BASE converts to any base from 2 to 36 and handles much bigger numbers than DEC2BIN.
Read article →ARABIC Function in Excel: Roman Numerals to Numbers
ARABIC Function in Excel: Roman Numerals to Numbers
ARABIC reads Roman numerals so you can sort “Part IX” correctly after “Part VIII”.
Read article →ROMAN Function in Excel: Numbers to Roman Numerals
ROMAN Function in Excel: Numbers to Roman Numerals
MathLevel: BeginnerAvailable in: Excel 2007+ROMAN turns 1–3999 into Roman numerals — chapter numbers, annual-report years.Syntax=ROMAN(number.
Read article →PI Function in Excel: The Value of π
PI Function in Excel: The Value of π
PI returns 3.14159265358979, accurate to 15 digits. It takes no arguments but still needs the brackets.
Read article →PRODUCT Function in Excel: Multiply Many Numbers
PRODUCT Function in Excel: Multiply Many Numbers
MathLevel: BeginnerAvailable in: Excel 2007+PRODUCT multiplies all numbers in its arguments, ignoring text and blanks.Syntax=PRODUCT(number1, [number2].
Read article →SUMSQ Function in Excel: Sum of Squares
SUMSQ Function in Excel: Sum of Squares
SUMSQ squares each value and adds them up — the building block of error measures such as RMSE.
Read article →AGGREGATE Function in Excel: SUBTOTAL That Can Ignore Errors
AGGREGATE Function in Excel: SUBTOTAL That Can Ignore Errors
AGGREGATE is like SUBTOTAL with 19 functions and extra options — most usefully, ignoring error values such as #N/A in the range.
Read article →SUBTOTAL Function in Excel: Totals That Respect Filters
SUBTOTAL Function in Excel: Totals That Respect Filters
SUBTOTAL calculates a sum, count, average and more while ignoring rows hidden by a filter. It also ignores other SUBTOTALs in the range, so…
Read article →SUMPRODUCT Function in Excel: Multiply Arrays and Add the Results
SUMPRODUCT Function in Excel: Multiply Arrays and Add the Results
SUMPRODUCT multiplies ranges row by row and adds the products. Because it handles arrays natively, it doubles as a flexible conditional sum and counter…
Read article →