Skip to content

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

All functions

  • ABSMUTLAKFull page

    Absolute value.

    =ABS(number)
  • CEILING.MATHTAVANAYUVARLA.MATEMATİKFull page

    Rounds up to the nearest integer or multiple.

    =CEILING.MATH(number, [significance], [mode])
  • INTTAMSAYIFull page

    Rounds down to the nearest integer.

    =INT(number)
  • MODFull page

    Remainder after division (takes the sign of the divisor).

    =MOD(number, divisor)
  • MROUNDKYUVARLAFull page

    Rounds to the nearest multiple.

    =MROUND(number, multiple)
  • ROUNDYUVARLAFull page

    Rounds a number to a number of digits.

    =ROUND(number, num_digits)
  • ROUNDDOWNAŞAĞIYUVARLAFull page

    Rounds toward zero.

    =ROUNDDOWN(number, num_digits)
  • ROUNDUPYUKARIYUVARLAFull page

    Rounds away from zero.

    =ROUNDUP(number, num_digits)
  • SEQUENCESIRALIFull page

    Array of sequential numbers.

    =SEQUENCE(rows, [columns], [start], [step])
  • SQRTKAREKÖKFull page

    Square root of a number.

    =SQRT(number)
  • SUBTOTALALTTOPLAMFull page

    Subtotal with a chosen function (9 = sum, 1 = average…).

    =SUBTOTAL(function_num, ref1, ...)
  • SUMTOPLAFull page

    Adds numbers or a whole column.

    =SUM(number1, [number2], ...)
  • SUMIFETOPLAFull page

    Adds the cells that meet a condition.

    =SUMIF(range, criteria, [sum_range])
  • SUMIFSÇOKETOPLAFull page

    Adds the cells that meet multiple conditions.

    =SUMIFS(sum_range, criteria_range1, criteria1, ...)
  • SUMPRODUCTTOPLA.ÇARPIMFull page

    Multiplies matching items of arrays and sums them; the classic conditional sum: SUMPRODUCT((City="Ankara")*Amount).

    =SUMPRODUCT(array1, [array2], ...)
  • TRUNCNSATFull page

    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)

Excel functions →

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