Excel functions · 83 functions
Excel math and sum functions
Functions for sums and conditional sums, rounding, remainders, powers and roots, random numbers and trigonometry. Everyday work leans on SUM, SUMIF, SUMIFS and ROUND.
Functions explained in full
- ABSAbsolute value.
- CEILING.MATHRounds up to the nearest integer or multiple.
- INTRounds down to the nearest integer.
- MODRemainder after division (takes the sign of the divisor).
- MROUNDRounds to the nearest multiple.
- ROUNDRounds a number to a number of digits.
- ROUNDDOWNRounds toward zero.
- ROUNDUPRounds away from zero.
- SEQUENCEArray of sequential numbers.
- SQRTSquare root of a number.
- SUBTOTALSubtotal with a chosen function (9 = sum, 1 = average…).
- SUMAdds numbers or a whole column.
- SUMIFAdds the cells that meet a condition.
- SUMIFSAdds the cells that meet multiple conditions.
- SUMPRODUCTMultiplies matching items of arrays and sums them; the classic conditional sum: SUMPRODUCT((City="Ankara")*Amount).
- TRUNCTruncates a number.
All functions
Absolute value.
=ABS(number)Rounds up to the nearest integer or multiple.
=CEILING.MATH(number, [significance], [mode])Rounds down to the nearest integer.
=INT(number)- MODFull page
Remainder after division (takes the sign of the divisor).
=MOD(number, divisor) Rounds to the nearest multiple.
=MROUND(number, multiple)Rounds a number to a number of digits.
=ROUND(number, num_digits)Rounds toward zero.
=ROUNDDOWN(number, num_digits)Rounds away from zero.
=ROUNDUP(number, num_digits)Array of sequential numbers.
=SEQUENCE(rows, [columns], [start], [step])Square root of a number.
=SQRT(number)Subtotal with a chosen function (9 = sum, 1 = average…).
=SUBTOTAL(function_num, ref1, ...)Adds numbers or a whole column.
=SUM(number1, [number2], ...)Adds the cells that meet a condition.
=SUMIF(range, criteria, [sum_range])Adds the cells that meet multiple conditions.
=SUMIFS(sum_range, criteria_range1, criteria1, ...)Multiplies matching items of arrays and sums them; the classic conditional sum: SUMPRODUCT((City="Ankara")*Amount).
=SUMPRODUCT(array1, [array2], ...)Truncates a number.
=TRUNC(number, [num_digits])- ACOS
Arccosine.
=ACOS(number) - ACOSH
Inverse hyperbolic cosine.
=ACOSH(number) - ACOT
Arccotangent.
=ACOT(number) - ACOTH
Inverse hyperbolic cotangent.
=ACOTH(number) - AGGREGATETOPLAMA
Aggregate that can ignore errors (option 6). 14 = LARGE, 15 = SMALL.
=AGGREGATE(function_num, options, ref1, ...) - ARABICARAP
Converts a Roman numeral to a number.
=ARABIC(text) - ASINASİN
Arcsine.
=ASIN(number) - ASINHASİNH
Inverse hyperbolic sine.
=ASINH(number) - ATAN
Arctangent.
=ATAN(number) - ATAN2
Arctangent from x and y coordinates.
=ATAN2(x_num, y_num) - ATANH
Inverse hyperbolic tangent.
=ATANH(number) - BASETABAN
Converts a number to text in another base.
=BASE(number, radix, [min_length]) - CEILINGTAVANAYUVARLA
Rounds up to a multiple of significance.
=CEILING(number, significance) - CEILING.PRECISETAVANAYUVARLA.DUYARLI
Rounds up regardless of sign.
=CEILING.PRECISE(number, [significance]) - COMBINKOMBİNASYON
Number of combinations.
=COMBIN(number, number_chosen) - COMBINAKOMBİNASYONA
Combinations with repetitions.
=COMBINA(number, number_chosen) - COS
Cosine of an angle in radians.
=COS(number) - COSH
Hyperbolic cosine.
=COSH(number) - COT
Cotangent of an angle in radians.
=COT(number) - COTH
Hyperbolic cotangent.
=COTH(number) - CSC
Cosecant of an angle in radians.
=CSC(number) - CSCH
Hyperbolic cosecant.
=CSCH(number) - DECIMALONDALIK
Converts text in a base to a decimal number.
=DECIMAL(text, radix) - DEGREESDERECE
Radians to degrees.
=DEGREES(angle) - ECMA.CEILINGECMA.TAVAN
Same as CEILING (ECMA compatibility).
=ECMA.CEILING(number, significance) - EVENÇİFT
Rounds away from zero to the nearest even integer.
=EVEN(number) - EXPÜS
e raised to a power.
=EXP(number) - FACTÇARPINIM
Factorial of a number: 5! = 120.
=FACT(number) - FACTDOUBLEÇİFTFAKTÖR
Double factorial.
=FACTDOUBLE(number) - FLOORTABANAYUVARLA
Rounds down to a multiple of significance.
=FLOOR(number, significance) - FLOOR.MATHTABANAYUVARLA.MATEMATİK
Rounds down to the nearest integer or multiple.
=FLOOR.MATH(number, [significance], [mode]) - FLOOR.PRECISETABANAYUVARLA.DUYARLI
Rounds down regardless of sign.
=FLOOR.PRECISE(number, [significance]) - GCDOBEB
Greatest common divisor.
=GCD(number1, [number2], ...) - ISO.CEILINGISO.TAVAN
Rounds up per ISO (same as CEILING.PRECISE).
=ISO.CEILING(number, [significance]) - LCMOKEK
Least common multiple.
=LCM(number1, [number2], ...) - LN
Natural logarithm.
=LN(number) - LOG
Logarithm (base 10 by default).
=LOG(number, [base]) - LOG10
Base-10 logarithm.
=LOG10(number) - MDETERMDETERMİNANT
Determinant of a square matrix.
=MDETERM(array) - MINVERSEDİZEY_TERS
Inverse of a square matrix.
=MINVERSE(array) - MMULTDÇARP
Matrix product of two arrays.
=MMULT(array1, array2) - MULTINOMIALÇOKTERİMLİ
Multinomial of a set of numbers.
=MULTINOMIAL(number1, [number2], ...) - MUNITBİRİMMATRİS
Identity matrix.
=MUNIT(dimension) - ODDTEK
Rounds away from zero to the nearest odd integer.
=ODD(number) - PERCENTOF
Sum of a subset divided by the sum of all data.
=PERCENTOF(data_subset, data_all) - PIPİ
Returns the number π (3.14159…).
=PI() - POWERKUVVET
Number raised to a power.
=POWER(number, power) - PRODUCTÇARPIM
Multiplies numbers.
=PRODUCT(number1, [number2], ...) - QUOTIENTBÖLÜM
Integer portion of a division.
=QUOTIENT(numerator, denominator) - RADIANSRADYAN
Degrees to radians.
=RADIANS(angle) - RANDS_SAYI_ÜRET
Random number between 0 and 1 (changes on every recalculation, in Excel too).
=RAND() - RANDARRAYRASGDİZİ
Array of random numbers (changes on recalculation).
=RANDARRAY([rows], [columns], [min], [max], [integer]) - RANDBETWEENRASTGELEARADA
Random integer between two numbers (changes on recalculation).
=RANDBETWEEN(bottom, top) - ROMANROMEN
Converts to Roman numerals.
=ROMAN(number, [form]) - SEC
Secant of an angle in radians.
=SEC(number) - SECH
Hyperbolic secant.
=SECH(number) - SERIESSUMSERİTOPLA
Sum of a power series.
=SERIESSUM(x, n, m, coefficients) - SIGNİŞARET
Sign of a number.
=SIGN(number) - SINSİN
Sine of an angle in radians.
=SIN(number) - SINHSİNH
Hyperbolic sine.
=SINH(number) - SQRTPIKAREKÖKPİ
Square root of number × π.
=SQRTPI(number) - SUMSQTOPKARE
Sum of squares.
=SUMSQ(number1, [number2], ...) - SUMX2MY2TOPX2EY2
Sum of differences of squares.
=SUMX2MY2(array_x, array_y) - SUMX2PY2TOPX2AY2
Sum of sums of squares.
=SUMX2PY2(array_x, array_y) - SUMXMY2TOPXEY2
Sum of squares of differences.
=SUMXMY2(array_x, array_y) - TAN
Tangent of an angle in radians.
=TAN(number) - TANH
Hyperbolic tangent.
=TANH(number)
Stop memorising formulas. Describe them.
Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.
Try it free