FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe)
FLOOR.PRECISE rounds down to a multiple regardless of signs; negatives round away from zero.
Read article →Math & Trig
Excel Math & Trig functions explained with syntax, examples and common mistakes.
PERMUTATIONA Function in Excel: Arrangements With Repeats
PERMUTATIONA Function in Excel: Arrangements With Repeats
PERMUTATIONA counts ordered arrangements where items can repeat: a 4-digit PIN has PERMUTATIONA(10,4) = 10,000.
Read article →MULTINOMIAL Function in Excel: Ways to Split Into Groups
MULTINOMIAL Function in Excel: Ways to Split Into Groups
MathLevel: ExpertAvailable in: Excel 2007+MULTINOMIAL counts ways to divide items into groups of given sizes.Syntax=MULTINOMIAL(number1, [number2].
Read article →FACTDOUBLE Function in Excel: Double Factorial
FACTDOUBLE Function in Excel: Double Factorial
MathLevel: ExpertAvailable in: Excel 2007+FACTDOUBLE multiplies every other number: 7!! = 7 × 5 × 3 × 1.Syntax=FACTDOUBLE(number)ArgumentWhat it.
Read article →COMBINA Function in Excel: Combinations With Repeats
COMBINA Function in Excel: Combinations With Repeats
COMBINA counts selections where the same item can be chosen more than once — scoops of ice cream from four flavours.
Read article →MUNIT Function in Excel: Identity Matrix
MUNIT Function in Excel: Identity Matrix
MUNIT returns an identity matrix — 1s on the diagonal, 0s elsewhere. Handy for checking MINVERSE results.
Read article →CEILING.PRECISE Function in Excel: Round Up to a Multiple (Sign-Safe)
CEILING.PRECISE Function in Excel: Round Up to a Multiple (Sign-Safe)
CEILING.PRECISE rounds up to a multiple regardless of the signs of number and significance; negatives round toward zero.
Read article →ISO.CEILING Function in Excel: Round Up, Ignoring the Sign
ISO.CEILING Function in Excel: Round Up, Ignoring the Sign
ISO.CEILING always rounds towards positive infinity, whatever the sign of the multiple — useful when data mixes positive and negative adjustments.
Read article →FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR rounds down to a multiple — full boxes you can ship, 15-minute billing blocks.
Read article →CEILING Function in Excel: Round Up to a Multiple (Classic)
CEILING Function in Excel: Round Up to a Multiple (Classic)
CEILING rounds up to the nearest multiple — prices ending in 5 or 9, pack sizes. CEILING.MATH is the newer version that handles negatives…
Read article →MDETERM Function in Excel: Determinant of a Matrix
MDETERM Function in Excel: Determinant of a Matrix
MDETERM returns the determinant. Zero means the equations have no unique solution.
Read article →MINVERSE Function in Excel: Inverse of a Matrix
MINVERSE Function in Excel: Inverse of a Matrix
MathLevel: ExpertAvailable in: Excel 2007+MINVERSE inverts a square matrix — with MMULT it solves simultaneous.
Read article →