ElyxAI

Excel Math and Trigonometry Formulas

Functions for performing mathematical calculations, from simple addition to advanced trigonometric formulas.

92 formulas
26 Beginner
37 Intermediate
29 Advanced

SUM

Beginner
=SUM(number1, [number2], ...)

SUMIF

Intermediate
=SUMIF(range, criteria, [sum_range])

SUMIFS

Intermediate
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

SUMPRODUCT

Advanced
=SUMPRODUCT(array1, [array2], [array3], ...)

AVERAGE

Beginner
=AVERAGE(number1, [number2], ...)

AVERAGEIF

Intermediate
=AVERAGEIF(range, criteria, [average_range])

AVERAGEIFS

Intermediate
=AVERAGEIFS(average_range, criteria_range1, criteria1, ...)

COUNT

Beginner
=COUNT(value1, [value2], ...)

COUNTA

Beginner
=COUNTA(value1, [value2], ...)

COUNTIF

Beginner
=COUNTIF(range, criteria)

COUNTIFS

Intermediate
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

COUNTBLANK

Beginner
=COUNTBLANK(range)

MAX

Beginner
=MAX(number1, [number2], ...)

MAXIFS

Intermediate
=MAXIFS(max_range, criteria_range1, criteria1, ...)

MIN

Beginner
=MIN(number1, [number2], ...)

MINIFS

Intermediate
=MINIFS(min_range, criteria_range1, criteria1, ...)

ABS

Beginner
=ABS(number)

ROUND

Beginner
=ROUND(number, num_digits)

ROUNDUP

Beginner
=ROUNDUP(number, num_digits)

ROUNDDOWN

Beginner
=ROUNDDOWN(number, num_digits)

MROUND

Intermediate
=MROUND(number, multiple)

CEILING

Intermediate
=CEILING(number, significance)

INT

Beginner
=INT(number)

TRUNC

Beginner
=TRUNC(number, [num_digits])

MOD

Intermediate
=MOD(number, divisor)

QUOTIENT

Beginner
=QUOTIENT(numerator, denominator)

POWER

Beginner
=POWER(number, power)

SQRT

Beginner
=SQRT(number)

EXP

Intermediate
=EXP(number)

LN

Intermediate
=LN(number)

LOG

Intermediate
=LOG(number, [base])

LOG10

Intermediate
=LOG10(number)

PRODUCT

Beginner
=PRODUCT(number1, [number2], ...)

RAND

Beginner
=RAND()

RANDBETWEEN

Beginner
=RANDBETWEEN(bottom, top)

RANDARRAY

Intermediate
=RANDARRAY([rows], [columns], [min], [max], [whole_number])

SIGN

Beginner
=SIGN(number)

PI

Beginner
=PI()

RADIANS

Intermediate
=RADIANS(angle)

DEGREES

Intermediate
=DEGREES(angle)

SIN

Intermediate
=SIN(number)

COS

Intermediate
=COS(number)

TAN

Intermediate
=TAN(number)

ASIN

Advanced
=ASIN(number)

ACOS

Advanced
=ACOS(number)

ATAN

Advanced
=ATAN(number)

ATAN2

Advanced
=ATAN2(x_num, y_num)

SINH

Advanced
=SINH(number)

COSH

Advanced
=COSH(number)

TANH

Advanced
=TANH(number)

FACT

Intermediate
=FACT(number)

COMBIN

Intermediate
=COMBIN(number, number_chosen)

GCD

Intermediate
=GCD(number1, [number2], ...)

LCM

Intermediate
=LCM(number1, [number2], ...)

EVEN

Beginner
=EVEN(number)

ODD

Beginner
=ODD(number)

ROMAN

Beginner
=ROMAN(number, [form])

ARABIC

Beginner
=ARABIC(text)

BASE

Intermediate
=BASE(number, radix, [min_length])

DECIMAL

Intermediate
=DECIMAL(text, radix)

SEQUENCE

Intermediate
=SEQUENCE(rows, [columns], [start], [step])

AGGREGATE

Advanced
=AGGREGATE(function_num, options, ref1, [ref2], ...)

SUBTOTAL

Intermediate
=SUBTOTAL(function_num, ref1, [ref2], ...)

ACOSH

Advanced
=ACOSH(number)

ACOT

Advanced
=ACOT(number)

ACOTH

Advanced
=ACOTH(number)

ASINH

Advanced
=ASINH(number)

ATANH

Advanced
=ATANH(number)

COT

Advanced
=COT(number)

COTH

Advanced
=COTH(number)

CSC

Advanced
=CSC(number)

CSCH

Advanced
=CSCH(number)

SEC

Advanced
=SEC(number)

SECH

Advanced
=SECH(number)

COMBINA

Intermediate
=COMBINA(number, number_chosen)

FACTDOUBLE

Intermediate
=FACTDOUBLE(number)

MULTINOMIAL

Advanced
=MULTINOMIAL(number1, [number2], ...)

SERIESSUM

Advanced
=SERIESSUM(x, n, m, coefficients)

SQRTPI

Intermediate
=SQRTPI(number)

SUMSQ

Intermediate
=SUMSQ(number1, [number2], ...)

SUMX2MY2

Advanced
=SUMX2MY2(array_x, array_y)

SUMX2PY2

Advanced
=SUMX2PY2(array_x, array_y)

SUMXMY2

Advanced
=SUMXMY2(array_x, array_y)

MDETERM

Advanced
=MDETERM(array)

MINVERSE

Advanced
=MINVERSE(array)

MMULT

Advanced
=MMULT(array1, array2)

MUNIT

Advanced
=MUNIT(dimension)

CEILING.MATH

Intermediate
=CEILING.MATH(number, [significance], [mode])

CEILING.PRECISE

Intermediate
=CEILING.PRECISE(number, [significance])

ISO.CEILING

Intermediate
=ISO.CEILING(number, [significance])

FLOOR.MATH

Intermediate
=FLOOR.MATH(number, [significance], [mode])

FLOOR.PRECISE

Intermediate
=FLOOR.PRECISE(number, [significance])