Basic Math Diagram
Basic math diagram
Trigonometry Math Diagram
Trigonometry math diagram
ABS
ABS(number)
ACOS
ACOS(number)
ACOSH
ACOSH(number)
ACOT
ACOT(number)
ACOTH
ACOTH(number)
AGGREGATE
AGGREGATE(function_num, options, ref1, [ref2], ...)
ARABIC
ARABIC(text)
ASIN
ASIN(number)
ASINH
ASINH(number)
ATAN
ATAN(number)
ATAN2
ATAN2(x_num, y_num)
ATANH
ATANH(number)
BASE
BASE(number, radix, [min_length])
CEILING.MATH
CEILING.MATH(number, [significance], [mode])
CEILING.PRECISE
CEILING.PRECISE(number, [significance])
COMBIN
COMBIN(number, number_chosen)
COMBINA
COMBINA(number, number_chosen)
COS
COS(number)
COSH
COSH(number)
COT
COT(number)
COTH
COTH(number)
CSC
CSC(number)
CSCH
CSCH(number)
DECIMAL
DECIMAL(text, radix)
DEGREES
DEGREES(angle)
EVEN
EVEN(number)
EXP
EXP(number)
FACT
FACT(number)
FACTDOUBLE
FACTDOUBLE(number)
FLOOR.MATH
FLOOR.MATH(number, [significance], [mode])
FLOOR.PRECISE
FLOOR.PRECISE(number, [significance])
GCD
GCD(number1, [number2], ...)
INT
INT(number)
ISO.CEILING
ISO.CEILING(number, [significance])
LCM
LCM(number1, [number2], ...)
LN
LN(number)
LOG
LOG(number, [base])
LOG10
LOG10(number)
MDETERM
MDETERM(array)
MINVERSE
MINVERSE(array)
MMULT
MMULT(array1, array2)
MOD
MOD(number, divisor)
MROUND
MROUND(number, multiple)
MULTINOMIAL
MULTINOMIAL(number1, [number2], ...)
MUNIT
MUNIT(dimension)
ODD
ODD(number)
PERCENTOF
PERCENTOF(data_subset, data_all)
PI
PI()
POWER
POWER(number, power)
PRODUCT
PRODUCT(number1, [number2], ...)
QUOTIENT
QUOTIENT(numerator, denominator)
RADIANS
RADIANS(angle)
RAND
RAND()
RANDARRAY
RANDARRAY([rows], [columns], [min], [max], [whole_number])
RANDBETWEEN
RANDBETWEEN(bottom, top)
ROMAN
ROMAN(number, [form])
ROUND
ROUND(number, num_digits)
ROUNDDOWN
ROUNDDOWN(number, num_digits)
ROUNDUP
ROUNDUP(number, num_digits)
SEC
SEC(number)
SECH
SECH(number)
SEQUENCE
SEQUENCE(rows, [columns], [start], [step])
SERIESSUM
SERIESSUM(x, n, m, coefficients)
SIGN
SIGN(number)
SIN
SIN(number)
SINH
SINH(number)
SQRT
SQRT(number)
SQRTPI
SQRTPI(number)
SUBTOTAL
SUBTOTAL(function_num, ref1, [ref2], ...)
SUM
SUM(number1, [number2], ...)
SUMIF
SUMIF(range, criteria, [sum_range])
SUMIFS
SUMIFS(sum_range, criteria_range1, ...)
SUMPRODUCT
SUMPRODUCT(array1, [array2], [array3], ...)
SUMSQ
SUMSQ(number1, [number2], ...)
SUMX2MY2
SUMX2MY2(array_x, array_y)
SUMX2PY2
SUMX2PY2(array_x, array_y)
SUMXMY2
SUMXMY2(array_x, array_y)
TAN
TAN(number)
TANH
TANH(number)
TRUNC
TRUNC(number, [num_digits])
Math and trigonometry
Math and trigonometry functions help to perform mathematical calculations.