Formula translator / Polish
Excel functions in Polish and English
Funkcje Excela po polsku i po angielsku
Excel in Polish has its own name for most functions: VLOOKUP is WYSZUKAJ.PIONOWO and IF is JEŻELI. Paste a formula to translate it either way, or look a function up in the list below.
An example
English: =IF(VLOOKUP(A2, Prices!A:C, 3, FALSE)>=1.5, "High", "Low")
Polish: =JEŻELI(WYSZUKAJ.PIONOWO(A2; Prices!A:C; 3; FAŁSZ)>=1,5; "High"; "Low")
In Polish, Excel usually separates arguments with a semicolon and writes decimals with a comma (1,5). Excel takes both from your computer's region settings.
All 470 functions in Polish and English
TRUE is PRAWDA and FALSE is FAŁSZ.
| English | Polish | What it does |
|---|---|---|
| ABS | MODUŁ.LICZBY | The absolute value: the number without its sign. |
| ACCRINT | NAL.ODS | |
| ACCRINTM | NAL.ODS.WYKUP | |
| ACOS | ACOS | The angle, in radians, whose cosine is the number. |
| ACOSH | ACOSH | The inverse hyperbolic cosine of a number. |
| ACOT | ACOT | The angle, in radians, whose cotangent is the number. The result is between 0 and π. |
| ACOTH | ACOTH | |
| ADDRESS | ADRES | Builds a cell address as text from a row number and a column number. |
| AGGREGATE | AGREGUJ | Like SUBTOTAL with more calculations, and it can ignore errors in the range. |
| AMORDEGRC | AMORT.NIELIN | |
| AMORLINC | AMORT.LIN | |
| AND | ORAZ | TRUE only if every condition is TRUE. |
| ARABIC | ARABSKIE | Turns Roman numerals into a number. |
| AREAS | OBSZARY | |
| ARRAYTOTEXT | TABLICA.NA.TEKST | All the values of a range written out as one piece of text. |
| ASIN | ASIN | The angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees. |
| ASINH | ASINH | The inverse hyperbolic sine of a number. |
| ATAN | ATAN | The angle, in radians, whose tangent is the number. |
| ATAN2 | ATAN2 | The angle, in radians, from the x-axis to the point (x, y). Unlike ATAN it knows which quarter of the circle the point is in. |
| ATANH | ATANH | The inverse hyperbolic tangent of a number. |
| AVEDEV | ODCH.ŚREDNIE | The average distance of the values from their mean: a plain measure of how spread out they are. |
| AVERAGE | ŚREDNIA | The arithmetic mean of the numbers. |
| AVERAGEA | ŚREDNIA.A | The average, counting text in a range as 0 and TRUE as 1. |
| AVERAGEIF | ŚREDNIA.JEŻELI | Averages the cells that meet a condition. |
| AVERAGEIFS | ŚREDNIA.WARUNKÓW | Averages the cells that meet every one of several conditions. |
| BAHTTEXT | BAT.TEKST | |
| BASE | PODSTAWA | Writes a number in another base, such as binary (2) or hexadecimal (16), as text. |
| BESSELI | BESSEL.I | |
| BESSELJ | BESSEL.J | |
| BESSELK | BESSEL.K | |
| BESSELY | BESSEL.Y | |
| BETA.DIST | ROZKŁ.BETA | The beta distribution, for shares and percentages that vary between two bounds. |
| BETA.INV | ROZKŁ.BETA.ODWR | The value below which a given share of a beta distribution falls. |
| BETADIST | ROZKŁAD.BETA | The chance of x or less in a beta distribution. The older form of BETA.DIST. |
| BETAINV | ROZKŁAD.BETA.ODW | |
| BIN2DEC | DWÓJK.NA.DZIES | Turns a binary number into an ordinary one. |
| BIN2HEX | DWÓJK.NA.SZESN | |
| BIN2OCT | DWÓJK.NA.ÓSM | |
| BINOM.DIST | ROZKŁ.DWUM | The chance of a number of successes in a set number of tries, each with the same chance. |
| BINOM.DIST.RANGE | ROZKŁ.DWUM.ZAKRES | The chance that the number of successes in a set of tries lands between two counts. |
| BINOM.INV | ROZKŁ.DWUM.ODWR | The smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for. |
| BINOMDIST | ROZKŁAD.DWUM | |
| BITAND | BITAND | Compares two whole numbers bit by bit and keeps the bits that are set in both. |
| BITLSHIFT | BIT.PRZESUNIĘCIE.W.LEWO | Moves the bits of a whole number to the left, which doubles it for every bit moved. |
| BITOR | BITOR | Compares two whole numbers bit by bit and keeps the bits that are set in either. |
| BITRSHIFT | BIT.PRZESUNIĘCIE.W.PRAWO | Moves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder. |
| BITXOR | BITXOR | Compares two whole numbers bit by bit and keeps the bits that are set in one but not the other. |
| CEILING | ZAOKR.W.GÓRĘ | Rounds a number up to the nearest multiple (away from zero when both are negative). |
| CEILING.MATH | ZAOKR.W.GÓRĘ.MATEMATYCZNE | Rounds a number up to the nearest multiple; mode rounds negative numbers away from zero. |
| CEILING.PRECISE | ZAOKR.W.GÓRĘ.DOKŁ | |
| CELL | KOMÓRKA | Tells you something about a cell: its address, row, column, contents, number format or the type of value in it. |
| CHAR | ZNAK | The character for a character code. |
| CHIDIST | ROZKŁAD.CHI | |
| CHIINV | ROZKŁAD.CHI.ODW | |
| CHISQ.DIST | ROZKŁ.CHI | The chi-square distribution: the chance of a value of x or less, or the height of the curve at x. |
| CHISQ.DIST.RT | ROZKŁ.CHI.PS | The right tail of the chi-square distribution: the chance of a value greater than x. This is the p-value of a chi-square statistic. |
| CHISQ.INV | ROZKŁ.CHI.ODWR | The value below which a given share of the chi-square distribution falls. |
| CHISQ.INV.RT | ROZKŁ.CHI.ODWR.PS | The chi-square value with a given share of the distribution above it: the critical value of a chi-square test. |
| CHISQ.TEST | CHI.TEST | The chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work. |
| CHITEST | TEST.CHI | |
| CHOOSE | WYBIERZ | Picks a value from a list by its position. |
| CHOOSECOLS | WYBIERZ.KOLUMNY | Returns the columns you name from an array, in the order you name them. |
| CLEAN | OCZYŚĆ | Removes non-printable characters. |
| CODE | KOD | The character code of the first character. |
| COLUMN | NR.KOLUMNY | The column number of a reference (A = 1). |
| COLUMNS | LICZBA.KOLUMN | How many columns a range has. |
| COMBIN | KOMBINACJE | How many ways to choose a number of items from a group, when the order does not matter. |
| COMBINA | KOMBINACJE.A | The number of ways to choose items when the same item may be chosen more than once and the order does not matter. |
| COMPLEX | LICZBA.ZESP | |
| CONCAT | ZŁĄCZ.TEKST | Joins text from several values or ranges. |
| CONCATENATE | ZŁĄCZ.TEKSTY | Joins several text values (older version of CONCAT). |
| CONFIDENCE | UFNOŚĆ | |
| CONFIDENCE.NORM | UFNOŚĆ.NORM | The margin of error for an average: add and subtract it to get the confidence interval. |
| CONFIDENCE.T | UFNOŚĆ.T | The margin of error of a sample mean, using Student's t-distribution. Add it to and subtract it from the mean for the confidence interval. |
| CONVERT | KONWERTUJ | Converts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius. |
| CORREL | WSP.KORELACJI | The correlation coefficient of two data sets: from −1 (opposite) through 0 (unrelated) to 1 (move together). |
| COS | COS | The cosine of an angle given in radians. |
| COSH | COSH | The hyperbolic cosine of a number. |
| COT | COT | The cotangent of an angle: 1 divided by its tangent. |
| COTH | COTH | |
| COUNT | ILE.LICZB | Counts cells that contain numbers. |
| COUNTA | ILE.NIEPUSTYCH | Counts cells that are not empty. |
| COUNTBLANK | LICZ.PUSTE | Counts empty cells in a range. |
| COUNTIF | LICZ.JEŻELI | Counts the cells that meet a condition. |
| COUNTIFS | LICZ.WARUNKI | Counts the rows that meet every one of several conditions. |
| COUPDAYBS | WYPŁ.DNI.OD.POCZ | |
| COUPDAYS | WYPŁ.DNI | |
| COUPDAYSNC | WYPŁ.DNI.NAST | |
| COUPNCD | WYPŁ.DATA.NAST | |
| COUPNUM | WYPŁ.LICZBA | |
| COUPPCD | WYPŁ.DATA.POPRZ | |
| COVAR | KOWARIANCJA | |
| COVARIANCE.P | KOWARIANCJA.POPUL | Population covariance: the average product of the deviations of each pair from their means. |
| COVARIANCE.S | KOWARIANCJA.PRÓBKI | Sample covariance: like COVARIANCE.P, but divides by n − 1 for a sample. |
| CRITBINOM | PRÓG.ROZKŁAD.DWUM | |
| CSC | CSC | The cosecant of an angle: 1 divided by its sine. |
| CSCH | CSCH | |
| CUBEKPIMEMBER | ELEMENT.KPI.MODUŁU | |
| CUBEMEMBER | ELEMENT.MODUŁU | |
| CUBEMEMBERPROPERTY | WŁAŚCIWOŚĆ.ELEMENTU.MODUŁU | |
| CUBERANKEDMEMBER | USZEREGOWANY.ELEMENT.MODUŁU | |
| CUBESET | ZESTAW.MODUŁÓW | |
| CUBESETCOUNT | LICZNIK.MODUŁÓW.ZESTAWU | |
| CUBEVALUE | WARTOŚĆ.MODUŁU | |
| CUMIPMT | SPŁAC.ODS | Total interest paid between two payment numbers. |
| CUMPRINC | SPŁAC.KAPIT | Total paid off the loan itself (not interest) between two payment numbers. |
| DATE | DATA | Builds a date from a year, month and day. |
| DATEDIF | DATA.RÓŻNICA | The difference between two dates in years, months or days. |
| DATEVALUE | DATA.WARTOŚĆ | Converts a date written as text into a date serial number. |
| DAVERAGE | BD.ŚREDNIA | The average of a column of a table for the rows that meet conditions written in cells. |
| DAY | DZIEŃ | The day of the month (1-31). |
| DAYS | DNI | The number of days between two dates. |
| DAYS360 | DNI.360 | Days between two dates in a year of twelve 30-day months, as some accounts count them. |
| DB | DB | Depreciation for one period, losing the same percentage of the remaining value each period. |
| DCOUNT | BD.ILE.REKORDÓW | Counts the numbers in a column of a table for the rows that meet conditions written in cells. |
| DCOUNTA | BD.ILE.REKORDÓW.A | Counts the cells that are not empty in a column of a table for the rows that meet conditions written in cells. |
| DDB | DDB | Depreciation for one period at double the straight-line rate (or another multiple). |
| DEC2BIN | DZIES.NA.DWÓJK | Writes a whole number in binary. |
| DEC2HEX | DZIES.NA.SZESN | Writes a whole number in hexadecimal. |
| DEC2OCT | DZIES.NA.ÓSM | |
| DECIMAL | DZIESIĘTNA | Turns a number written in another base, as text, into an ordinary number. |
| DEGREES | STOPNIE | Turns radians into degrees. |
| DELTA | CZY.RÓWNE | Tests whether two numbers are equal: 1 when they are, 0 when they are not. |
| DEVSQ | ODCH.KWADRATOWE | The sum of the squared distances of the values from their mean. |
| DGET | BD.POLE | The one value in a column of a table from the single row that meets the conditions. Two matching rows are an error, which makes it a strict lookup. |
| DISC | STOPA.DYSK | |
| DMAX | BD.MAX | The largest number in a column of a table among the rows that meet conditions written in cells. |
| DMIN | BD.MIN | The smallest number in a column of a table among the rows that meet conditions written in cells. |
| DOLLAR | KWOTA | A number as text in currency style: $1,234.57, with negatives in brackets. |
| DOLLARDE | CENA.DZIES | Turns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal. |
| DOLLARFR | CENA.UŁAM | Turns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02. |
| DPRODUCT | BD.ILOCZYN | Multiplies the numbers in a column of a table for the rows that meet conditions written in cells. |
| DROP | POMIŃ | Removes the first or last rows or columns of an array. |
| DSTDEV | BD.ODCH.STANDARD | The standard deviation of a column of a table for the matching rows, treating them as a sample. |
| DSTDEVP | BD.ODCH.STANDARD.POPUL | The standard deviation of a column of a table for the matching rows, treating them as the whole population. |
| DSUM | BD.SUMA | Adds up a column of a table for the rows that meet conditions written in cells. |
| DVAR | BD.WARIANCJA | The variance of a column of a table for the matching rows, treating them as a sample. |
| DVARP | BD.WARIANCJA.POPUL | The variance of a column of a table for the matching rows, treating them as the whole population. |
| EDATE | NR.SER.DATY | The same day a number of months before or after a date. |
| EFFECT | EFEKTYWNA | The yearly rate you really pay or earn, once interest is added several times a year. |
| ENCODEURL | ENCODEURL | Text made safe to put in a web address: spaces become %20, and so on. |
| EOMONTH | NR.SER.OST.DN.MIES | The last day of the month, a number of months away. |
| ERF | FUNKCJA.BŁ | The error function between two limits. With one limit it runs from 0. |
| ERF.PRECISE | FUNKCJA.BŁ.DOKŁ | The error function from 0 to x. |
| ERFC | KOMP.FUNKCJA.BŁ | The complementary error function: 1 - ERF(x). |
| ERROR.TYPE | NR.BŁĘDU | A number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A. |
| EVEN | ZAOKR.DO.PARZ | Rounds away from zero to the next even integer. |
| EXACT | PORÓWNAJ | TRUE if two text values are exactly the same, including case. |
| EXP | EXP | e raised to a power. |
| EXPAND | ROZSZERZ | Grows an array to a set number of rows and columns, filling the new cells. |
| EXPON.DIST | ROZKŁ.EXP | The exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less. |
| EXPONDIST | ROZKŁAD.EXP | |
| F.DIST | ROZKŁ.F | The F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x. |
| F.DIST.RT | ROZKŁ.F.PS | The right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic. |
| F.INV | ROZKŁ.F.ODWR | The value below which a given share of the F-distribution falls. |
| F.INV.RT | ROZKŁ.F.ODWR.PS | The F value with a given share of the distribution above it: the critical value of an F-test. |
| F.TEST | F.TEST | The F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed. |
| FACT | SILNIA | Factorial: 1 × 2 × … × n. |
| FACTDOUBLE | SILNIA.DWUKR | The double factorial: the number times every second whole number below it (7 × 5 × 3 × 1). |
| FDIST | ROZKŁAD.F | |
| FILTERXML | FILTERXML | |
| FIND | ZNAJDŹ | Position of one text inside another (case-sensitive). |
| FINV | ROZKŁAD.F.ODW | |
| FISHER | ROZKŁAD.FISHER | The Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested. |
| FISHERINV | ROZKŁAD.FISHER.ODW | Turns a Fisher-transformed value back into a correlation. |
| FIXED | ZAOKR.DO.TEKST | A number as text, rounded to a set number of decimals, with or without commas. |
| FLOOR | ZAOKR.W.DÓŁ | Rounds a number down to the nearest multiple (toward zero when both are negative). |
| FLOOR.MATH | ZAOKR.W.DÓŁ.MATEMATYCZNE | Rounds a number down to the nearest multiple; mode rounds negative numbers toward zero. |
| FLOOR.PRECISE | ZAOKR.W.DÓŁ.DOKŁ | |
| FORECAST | REGLINX | Predicts a y value for a new x from the best-fit straight line through known data. |
| FORMULATEXT | FORMUŁA.TEKST | Shows the formula in a cell as text. |
| FREQUENCY | CZĘSTOŚĆ | Counts how many values fall into each bin, for a histogram. Spills one more count than there are bins: the last counts values above the top bin. |
| FTEST | TEST.F | |
| FV | FV | The future value of an investment with regular payments. |
| FVSCHEDULE | WART.PRZYSZŁ.KAP | What an amount grows to when the interest rate changes from period to period. |
| GAMMA | GAMMA | The gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)! |
| GAMMA.DIST | ROZKŁ.GAMMA | The gamma distribution, for values that cannot be negative and lean to the right, such as waiting times. |
| GAMMA.INV | ROZKŁ.GAMMA.ODWR | The value below which a given share of a gamma distribution falls. |
| GAMMADIST | ROZKŁAD.GAMMA | |
| GAMMAINV | ROZKŁAD.GAMMA.ODW | |
| GAMMALN | ROZKŁAD.LIN.GAMMA | The natural logarithm of the gamma function. It stays small where GAMMA itself would overflow. |
| GAMMALN.PRECISE | ROZKŁAD.LIN.GAMMA.DOKŁ | |
| GAUSS | GAUSS | The chance that a standard normal value falls between the mean and z standard deviations above it. |
| GCD | NAJW.WSP.DZIEL | Greatest common divisor. |
| GEOMEAN | ŚREDNIA.GEOMETRYCZNA | The geometric mean: the right average for growth rates. |
| GESTEP | SPRAWDŹ.PRÓG | Tests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not. |
| GETPIVOTDATA | WEŹDANETABELI | Reads one value out of a PivotTable by naming it, so that the formula still finds it when the PivotTable grows or is sorted. |
| GROWTH | REGEXPW | Values on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills. |
| HARMEAN | ŚREDNIA.HARMONICZNA | The harmonic mean: the right average for rates such as speeds. |
| HEX2BIN | SZESN.NA.DWÓJK | |
| HEX2DEC | SZESN.NA.DZIES | Turns a hexadecimal number into an ordinary one. |
| HEX2OCT | SZESN.NA.ÓSM | |
| HLOOKUP | WYSZUKAJ.POZIOMO | Finds a value in the first row of a table and returns a value from the same column. |
| HOUR | GODZINA | The hour of a time (0-23). |
| HSTACK | STOS.POZ | Places arrays side by side into one wider array. |
| HYPERLINK | HIPERŁĄCZE | Makes a cell a link: to a web page, an email address, or another cell ("#Sheet2!A1"). Select the cell and click its link button, or Ctrl+click it, to follow the link. |
| HYPGEOM.DIST | ROZKŁ.HIPERGEOM | The hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back. |
| HYPGEOMDIST | ROZKŁAD.HIPERGEOM | The chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST. |
| IF | JEŻELI | Returns one value if a condition is TRUE and another if it is FALSE. |
| IFERROR | JEŻELI.BŁĄD | Returns a fallback value if a formula results in an error. |
| IFNA | JEŻELI.ND | Returns a fallback value only for #N/A errors. |
| IFS | WARUNKI | Checks conditions in order and returns the value for the first TRUE one. |
| IMABS | MODUŁ.LICZBY.ZESP | |
| IMAGINARY | CZ.UROJ.LICZBY.ZESP | |
| IMARGUMENT | ARG.LICZBY.ZESP | |
| IMCONJUGATE | SPRZĘŻ.LICZBY.ZESP | |
| IMCOS | COS.LICZBY.ZESP | |
| IMCOSH | COSH.LICZBY.ZESP | |
| IMCOT | COT.LICZBY.ZESP | |
| IMCSC | CSC.LICZBY.ZESP | |
| IMCSCH | CSCH.LICZBY.ZESP | |
| IMDIV | ILORAZ.LICZB.ZESP | |
| IMEXP | EXP.LICZBY.ZESP | |
| IMLN | LN.LICZBY.ZESP | |
| IMLOG10 | LOG10.LICZBY.ZESP | |
| IMLOG2 | LOG2.LICZBY.ZESP | |
| IMPOWER | POTĘGA.LICZBY.ZESP | |
| IMPRODUCT | ILOCZYN.LICZB.ZESP | |
| IMREAL | CZ.RZECZ.LICZBY.ZESP | |
| IMSEC | SEC.LICZBY.ZESP | |
| IMSECH | SECH.LICZBY.ZESP | |
| IMSIN | SIN.LICZBY.ZESP | |
| IMSINH | SINH.LICZBY.ZESP | |
| IMSQRT | PIERWIASTEK.LICZBY.ZESP | |
| IMSUB | RÓŻN.LICZB.ZESP | |
| IMSUM | SUMA.LICZB.ZESP | |
| IMTAN | TAN.LICZBY.ZESP | |
| INDEX | INDEKS | The value at a given row and column of a range. |
| INDIRECT | ADR.POŚR | Turns text such as "B2" into a real reference to that cell or range. |
| INFO | INFO | |
| INT | ZAOKR.DO.CAŁK | Rounds down to the nearest whole number. |
| INTERCEPT | ODCIĘTA | Where the best-fit straight line crosses the y axis: the predicted y when x is 0. |
| INTRATE | STOPA.PROC | |
| IPMT | IPMT | The interest part of one loan payment. |
| IRR | IRR | Internal rate of return for a series of cash flows. |
| ISBLANK | CZY.PUSTA | TRUE if the cell is empty. |
| ISERR | CZY.BŁ | TRUE if the value is any error except #N/A. |
| ISERROR | CZY.BŁĄD | TRUE if the value is any error. |
| ISEVEN | CZY.PARZYSTE | TRUE if the number is even. |
| ISFORMULA | CZY.FORMUŁA | TRUE if the cell holds a formula. |
| ISLOGICAL | CZY.LOGICZNA | TRUE if the value is TRUE or FALSE. |
| ISNA | CZY.BRAK | TRUE if the value is the #N/A error. |
| ISNONTEXT | CZY.NIE.TEKST | TRUE if the value is not text. |
| ISNUMBER | CZY.LICZBA | TRUE if the value is a number (dates count too). |
| ISODD | CZY.NIEPARZYSTE | TRUE if the number is odd. |
| ISOWEEKNUM | ISO.NUM.TYG | The ISO 8601 week number: weeks start on Monday, and week 1 contains the first Thursday of the year. |
| ISPMT | ISPMT | The interest paid in a period of a loan that is repaid in equal amounts of principal, so the interest falls every period. |
| ISREF | CZY.ADR | TRUE if the value is a reference to a cell or range. |
| ISTEXT | CZY.TEKST | TRUE if the value is text. |
| KURT | KURTOZA | Kurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values. |
| LARGE | MAX.K | The k-th largest value (k = 1 is the maximum). |
| LCM | NAJMN.WSP.WIEL | Least common multiple. |
| LEFT | LEWY | The first characters of a text value. |
| LEN | DŁ | The number of characters in a text value. |
| LINEST | REGLINP | Fits a straight line by least squares and returns its slope(s) and intercept, with the full regression statistics (standard errors, R², F, sums of squares) if you ask. Spills. |
| LN | LN | Natural logarithm. |
| LOG | LOG | Logarithm to a base (default 10). |
| LOG10 | LOG10 | Base-10 logarithm. |
| LOGEST | REGEXPP | Fits an exponential curve, y = b × m^x, and returns the growth factor m and the starting value b, with the regression statistics if you ask. Spills. |
| LOGINV | ROZKŁAD.LOG.ODW | |
| LOGNORM.DIST | ROZKŁ.LOG | The lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes. |
| LOGNORM.INV | ROZKŁ.LOG.ODWR | The value below which a given share of a lognormal distribution falls. |
| LOGNORMDIST | ROZKŁAD.LOG | The chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST. |
| LOOKUP | WYSZUKAJ | Finds a value in a sorted row or column and returns the value in the same place in another. XLOOKUP is the modern choice. |
| LOWER | LITERY.MAŁE | Converts text to lowercase. |
| MATCH | PODAJ.POZYCJĘ | The position of a value in a row or column. |
| MAX | MAX | The largest number. |
| MAXA | MAX.A | The largest value, counting text in a range as 0 and TRUE as 1. |
| MAXIFS | MAKS.WARUNKÓW | The largest value among cells that meet conditions. |
| MDETERM | WYZNACZNIK.MACIERZY | The determinant of a square matrix. |
| MDURATION | ROCZ.PRZYCH.M | |
| MEDIAN | MEDIANA | The middle number of a sorted list. |
| MID | FRAGMENT.TEKSTU | Characters from the middle of a text value. |
| MIN | MIN | The smallest number. |
| MINA | MIN.A | The smallest value, counting text in a range as 0 and TRUE as 1. |
| MINIFS | MIN.WARUNKÓW | The smallest value among cells that meet conditions. |
| MINUTE | MINUTA | The minute of a time (0-59). |
| MINVERSE | MACIERZ.ODW | The inverse of a square matrix. |
| MIRR | MIRR | Rate of return when money borrowed and money reinvested earn different rates. |
| MMULT | MACIERZ.ILOCZYN | Multiplies two matrices. |
| MOD | MOD | The remainder after division. |
| MODE | WYST.NAJCZĘŚCIEJ | The most frequently occurring number. |
| MODE.MULT | WYST.NAJCZĘŚCIEJ.TABL | Every value that is tied for most common, as a list. |
| MODE.SNGL | WYST.NAJCZĘŚCIEJ.WART | |
| MONTH | MIESIĄC | The month of a date (1-12). |
| MROUND | ZAOKR.DO.WIELOKR | Rounds to the nearest multiple of a number. |
| MULTINOMIAL | WIELOMIAN | The number of ways to split a group into smaller groups of the given sizes: the factorial of the total, divided by the factorial of each size. |
| MUNIT | MACIERZ.JEDNOSTKOWA | The unit matrix of a given size: 1 down the diagonal and 0 everywhere else. |
| N | N | Converts a value to a number (text becomes 0). |
| NA | BRAK | Returns the #N/A error on purpose. |
| NEGBINOM.DIST | ROZKŁ.DWUM.PRZEC | The negative binomial distribution: the chance of a number of failures before a given number of successes. |
| NEGBINOMDIST | ROZKŁAD.DWUM.PRZEC | The chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST. |
| NETWORKDAYS | DNI.ROBOCZE | Working days (Monday–Friday) between two dates, inclusive. |
| NETWORKDAYS.INTL | DNI.ROBOCZE.NIESTAND | Working days between two dates, inclusive, with the weekend on days you choose. |
| NOMINAL | NOMINALNA | The quoted yearly rate behind an effective rate. The reverse of EFFECT. |
| NORM.DIST | ROZKŁ.NORMALNY | The normal distribution: the chance of a value at or below x, or the height of the bell curve at x. |
| NORM.INV | ROZKŁ.NORMALNY.ODWR | The value below which a given share of a normal distribution falls. |
| NORM.S.DIST | ROZKŁ.NORMALNY.S | The standard normal distribution (mean 0, standard deviation 1) at a z-score. |
| NORM.S.INV | ROZKŁ.NORMALNY.S.ODWR | The z-score below which a given share of the standard normal distribution falls. |
| NORMDIST | ROZKŁAD.NORMALNY | |
| NORMINV | ROZKŁAD.NORMALNY.ODW | |
| NORMSDIST | ROZKŁAD.NORMALNY.S | The chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST. |
| NORMSINV | ROZKŁAD.NORMALNY.S.ODW | |
| NOT | NIE | Flips TRUE to FALSE and FALSE to TRUE. |
| NOW | TERAZ | The current date and time. |
| NPER | NPER | How many payment periods are needed to pay off a loan. |
| NPV | NPV | Net present value of future cash flows at a discount rate. |
| NUMBERVALUE | WARTOŚĆ.LICZBOWA | Turns text into a number, whatever decimal and thousands marks it uses. |
| OCT2BIN | ÓSM.NA.DWÓJK | |
| OCT2DEC | ÓSM.NA.DZIES | |
| OCT2HEX | ÓSM.NA.SZESN | |
| ODD | ZAOKR.DO.NPARZ | Rounds away from zero to the next odd integer. |
| ODDFPRICE | CENA.PIERW.OKR | |
| ODDFYIELD | RENT.PIERW.OKR | |
| ODDLPRICE | CENA.OST.OKR | |
| ODDLYIELD | RENT.OST.OKR | |
| OFFSET | PRZESUNIĘCIE | A range a set number of rows and columns away from a starting cell, of any size. |
| OR | LUB | TRUE if at least one condition is TRUE. |
| PDURATION | O.CZAS.TRWANIA | How many periods an investment needs to reach a target at a steady rate. |
| PEARSON | PEARSON | The Pearson correlation coefficient, the same as CORREL. |
| PERCENTILE | PERCENTYL | The value below which a given percentage of the data falls. |
| PERCENTILE.EXC | PERCENTYL.PRZEDZ.OTW | The value below which a percentage of the data falls, excluding 0% and 100%. |
| PERCENTILE.INC | PERCENTYL.PRZEDZ.ZAMK | |
| PERCENTRANK | PROCENT.POZYCJA | |
| PERCENTRANK.EXC | PROC.POZ.PRZEDZ.OTW | Where a value stands in a list, between 0 and 1 without ever reaching either. |
| PERCENTRANK.INC | PROC.POZ.PRZEDZ.ZAMK | Where a value stands in a list, from 0 (the lowest) to 1 (the highest). |
| PERMUT | PERMUTACJE | How many ways to pick a number of items from a group, when the order matters. |
| PERMUTATIONA | PERMUTACJE.A | The number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen. |
| PHI | PHI | The height of the standard normal bell curve at x. |
| PI | PI | The number π (3.14159…). |
| PMT | PMT | The payment for a loan with constant payments and a constant interest rate. |
| POISSON | ROZKŁAD.POISSON | |
| POISSON.DIST | ROZKŁ.POISSON | The chance of a number of events in a period, given how many happen on average. |
| POWER | POTĘGA | Raises a number to a power (same as ^). |
| PPMT | PPMT | The principal (pay-down) part of one loan payment. |
| PRICE | CENA | |
| PRICEDISC | CENA.DYSK | |
| PRICEMAT | CENA.WYKUP | |
| PROB | PRAWDPD | Adds up the probabilities of the outcomes that fall between two limits. |
| PRODUCT | ILOCZYN | Multiplies all the numbers together. |
| PROPER | Z.WIELKIEJ.LITERY | Capitalises The First Letter Of Each Word. |
| PV | PV | The present value: what a series of future payments is worth now. |
| QUARTILE | KWARTYL | A quartile of the data (0 = min, 2 = median, 4 = max). |
| QUARTILE.EXC | KWARTYL.PRZEDZ.OTW | A quartile of the data (1, 2 or 3), using the exclusive method. |
| QUARTILE.INC | KWARTYL.PRZEDZ.ZAMK | |
| QUOTIENT | CZ.CAŁK.DZIELENIA | The whole-number part of a division. |
| RADIANS | RADIANY | Turns degrees into radians, which is what SIN, COS and TAN take. |
| RAND | LOS | A random number between 0 and 1. Changes on every edit. |
| RANDARRAY | LOSOWA.TABLICA | Fills an array with random numbers. |
| RANDBETWEEN | LOS.ZAKR | A random whole number between two limits. |
| RANK | POZYCJA | The position of a number in a list (1 = largest by default). |
| RANK.AVG | POZYCJA.ŚR | The position of a number in a list. Tied values share the average of their positions. |
| RATE | RATE | The interest rate per period of a loan or investment. |
| RECEIVED | KWOTA.WYKUP | |
| REPLACE | ZASTĄP | Replaces characters at a given position. |
| REPT | POWT | Repeats text a number of times. |
| RIGHT | PRAWY | The last characters of a text value. |
| ROMAN | RZYMSKIE | Writes a number in Roman numerals. |
| ROUND | ZAOKR | Rounds a number to a given number of digits. |
| ROUNDDOWN | ZAOKR.DÓŁ | Rounds a number towards zero. |
| ROUNDUP | ZAOKR.GÓRA | Rounds a number away from zero. |
| ROW | WIERSZ | The row number of a reference (or of the current cell). |
| ROWS | ILE.WIERSZY | How many rows a range has. |
| RRI | RÓWNOW.STOPA.PROC | The steady growth rate per period that turns one amount into another (CAGR). |
| RSQ | R.KWADRAT | R squared: the share of the variation in y that the best-fit line explains, from 0 to 1. |
| RTD | DANE.CZASU.RZECZ | |
| SEARCH | SZUKAJ.TEKST | Position of one text inside another (not case-sensitive, allows wildcards). |
| SEC | SEC | The secant of an angle: 1 divided by its cosine. |
| SECH | SECH | |
| SECOND | SEKUNDA | The second of a time (0-59). |
| SEQUENCE | SEKWENCJA | Generates a list of sequential numbers that spills into neighbouring cells. |
| SERIESSUM | SUMA.SZER.POT | The sum of a power series: each coefficient times x raised to a power that grows by a fixed step. |
| SHEET | ARKUSZ | The number of a sheet, counting the tabs from the left: 1 for the first. |
| SHEETS | ARKUSZE | How many sheets the workbook has. |
| SIGN | ZNAK.LICZBY | 1 for positive numbers, -1 for negative, 0 for zero. |
| SIN | SIN | The sine of an angle given in radians. |
| SINH | SINH | The hyperbolic sine of a number. |
| SKEW | SKOŚNOŚĆ | Skewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values. |
| SKEW.P | SKOŚNOŚĆ.P | How lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left. |
| SLN | SLN | Straight-line depreciation: the same loss of value every year. |
| SLOPE | NACHYLENIE | The slope of the straight line that best fits the data: how much y changes for each 1 added to x. |
| SMALL | MIN.K | The k-th smallest value (k = 1 is the minimum). |
| SORT | SORTUJ | Sorts a range. The result spills. |
| SORTBY | SORTUJ.WEDŁUG | Sorts a range by the values in another range. |
| SQRT | PIERWIASTEK | Square root. |
| SQRTPI | PIERW.PI | The square root of a number multiplied by π. |
| STANDARDIZE | NORMALIZUJ | A z-score: how many standard deviations a value is above (or below) the mean. |
| STDEV | ODCH.STANDARDOWE | Standard deviation of a sample. |
| STDEV.P | ODCH.STAND.POPUL | Standard deviation of an entire population. |
| STDEV.S | ODCH.STANDARD.PRÓBKI | |
| STDEVA | ODCH.STANDARDOWE.A | The standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them. |
| STDEVP | ODCH.STANDARD.POPUL | |
| STDEVPA | ODCH.STANDARD.POPUL.A | The standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them. |
| STEYX | REGBŁSTD | The standard error of the regression: the typical distance of a y value from the best-fit line. |
| SUBSTITUTE | PODSTAW | Replaces specific text with new text. |
| SUBTOTAL | SUMY.CZĘŚCIOWE | Totals a range, leaving out rows that a filter hides and other subtotals inside it. |
| SUM | SUMA | Adds up numbers, cells and ranges. |
| SUMIF | SUMA.JEŻELI | Adds the cells that meet one condition. |
| SUMIFS | SUMA.WARUNKÓW | Adds the cells that meet every one of several conditions. |
| SUMPRODUCT | SUMA.ILOCZYNÓW | Multiplies matching items in arrays, then adds the results. |
| SUMSQ | SUMA.KWADRATÓW | Adds the squares of the numbers. |
| SUMX2MY2 | SUMA.X2.M.Y2 | Adds up the differences of the squares of matching values in two ranges. |
| SUMX2PY2 | SUMA.X2.P.Y2 | Adds up the sums of the squares of matching values in two ranges. |
| SUMXMY2 | SUMA.XMY.2 | Adds up the squares of the differences of matching values in two ranges. |
| SWITCH | PRZEŁĄCZ | Compares a value against a list and returns the matching result. |
| SYD | SYD | Sum-of-years’ digits depreciation: more in the early periods, less in the late ones. |
| T | T | Returns the value if it is text, otherwise empty text. |
| T.DIST | ROZKŁ.T | Student's t-distribution: the chance of a t of x or less, or the height of the curve at x. |
| T.DIST.2T | ROZKŁ.T.DS | The two-tailed t-distribution: the chance of a t further from 0 than x, on either side. This is the p-value of a two-sided t-test. |
| T.DIST.RT | ROZKŁ.T.PS | The right tail of the t-distribution: the chance of a t greater than x. |
| T.INV | ROZKŁ.T.ODWR | The t-value below which a given share of the t-distribution falls. |
| T.INV.2T | ROZKŁ.T.ODWR.DS | The t-value with a given share of the distribution beyond it, counting both tails. This is the critical value of a two-sided test. |
| T.TEST | T.TEST | Student's t-test: the chance that two samples would differ this much if they came from populations with the same mean. |
| TAN | TAN | The tangent of an angle given in radians. |
| TANH | TANH | The hyperbolic tangent of a number. |
| TBILLEQ | RENT.EKW.BS | |
| TBILLPRICE | CENA.BS | |
| TBILLYIELD | RENT.BS | |
| TDIST | ROZKŁAD.T | The tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T. |
| TEXT | TEKST | Formats a number as text using a format code. |
| TEXTAFTER | TEKST.PO | The text that comes after a delimiter. |
| TEXTBEFORE | TEKST.PRZED | The text that comes before a delimiter. |
| TEXTJOIN | POŁĄCZ.TEKSTY | Joins text with a separator between each item. |
| TEXTSPLIT | PODZIEL.TEKST | Splits text into separate cells at a delimiter. The result spills. |
| TIME | CZAS | Builds a time from hours, minutes and seconds. |
| TIMEVALUE | CZAS.WARTOŚĆ | Converts a time written as text into a fraction of a day. |
| TINV | ROZKŁAD.T.ODW | |
| TODAY | DZIŚ | Today's date. Updates automatically. |
| TOROW | DO.WIERSZA | Turns an array into a single row. |
| TRANSPOSE | TRANSPONUJ | Flips rows into columns and columns into rows. |
| TREND | REGLINW | Values on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills. |
| TRIM | USUŃ.ZBĘDNE.ODSTĘPY | Removes extra spaces, leaving single spaces between words. |
| TRIMMEAN | ŚREDNIA.WEWN | The average with a share of the highest and lowest values left out. |
| TRUNC | LICZBA.CAŁK | Cuts off the decimal part of a number. |
| TTEST | TEST.T | |
| TYPE | TYP | A number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array. |
| UNICHAR | ZNAK.UNICODE | The character with a Unicode number: letters of any alphabet, symbols, emoji. |
| UNICODE | UNICODE | The Unicode number of the first character of some text. |
| UNIQUE | UNIKATOWE | Removes duplicates from a list. The result spills. |
| UPPER | LITERY.WIELKIE | Converts text to UPPERCASE. |
| VALUE | WARTOŚĆ | Converts text that looks like a number into a number. |
| VALUETOTEXT | WARTOŚĆ.NA.TEKST | Any value as text. Text passes through unchanged, or in quotes in the strict format. |
| VAR | WARIANCJA | Variance of a sample. |
| VAR.P | WARIANCJA.POP | Variance of an entire population. |
| VAR.S | WARIANCJA.PRÓBKI | |
| VARA | WARIANCJA.A | The variance of a sample, counting text and FALSE in a range as 0 and TRUE as 1. VAR skips them. |
| VARP | WARIANCJA.POPUL | |
| VARPA | WARIANCJA.POPUL.A | The variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them. |
| VDB | VDB | Depreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more. |
| VLOOKUP | WYSZUKAJ.PIONOWO | Finds a value in the first column of a table and returns a value from the same row. |
| VSTACK | STOS.PION | Stacks arrays on top of each other into one taller array. |
| WEBSERVICE | WEBSERVICE | |
| WEEKDAY | DZIEŃ.TYG | The day of the week as a number. |
| WEEKNUM | NUM.TYG | The week number of the year. |
| WEIBULL | ROZKŁAD.WEIBULL | |
| WEIBULL.DIST | ROZKŁ.WEIBULL | The Weibull distribution, used for how long things last before they fail. |
| WORKDAY | DZIEŃ.ROBOCZY | The date a number of working days before or after a date. |
| WORKDAY.INTL | DZIEŃ.ROBOCZY.NIESTAND | The date a number of working days before or after a date, with the weekend on days you choose. |
| WRAPROWS | ZAWIŃ.WIERSZE | Wraps a row or column of values into rows of a set length. |
| XIRR | XIRR | The yearly rate of return for cash flows that fall on any dates. |
| XLOOKUP | X.WYSZUKAJ | Searches a range and returns the matching item from another range. The modern replacement for VLOOKUP. |
| XMATCH | X.DOPASUJ | The position of a value in a list, with exact match by default. |
| XNPV | XNPV | Net present value of cash flows that fall on any dates, not evenly spaced ones. |
| XOR | XOR | TRUE if an odd number of conditions are TRUE. |
| YEAR | ROK | The year of a date. |
| YEARFRAC | CZĘŚĆ.ROKU | The fraction of a year between two dates, using a day-count basis. |
| YIELDDISC | RENT.DYSK | |
| YIELDMAT | RENT.WYKUP | |
| Z.TEST | Z.TEST | The one-tailed z-test: the chance of a sample mean this far above a claimed population mean. |
| ZTEST | TEST.Z |
How it works
A workbook is not tied to a language. Excel stores every formula the same way and shows it in the language of whoever opens the file, so a file made in Polish Excel works in English Excel without changes. The names only get in the way when a formula travels as text: in a tutorial, a forum answer, an email or a chat.
The translator changes four things: function names, the separator between arguments, the decimal point, and TRUE, FALSE and error values such as #N/A. Text in quotes, cell references and sheet names stay exactly as you wrote them. Every name was checked against two sources before it was added; where a name could not be confirmed, the translator leaves the English one and tells you.
Other languages
- Czech (Čeština): SVYHLEDAT, KDYŽ, SUMIF
- Danish (Dansk): LOPSLAG, HVIS, SUM.HVIS
- Dutch (Nederlands): VERT.ZOEKEN, ALS, SOM.ALS
- Finnish (Suomi): PHAKU, JOS, SUMMA.JOS
- French (Français): RECHERCHEV, SI, SOMME.SI
- German (Deutsch): SVERWEIS, WENN, SUMMEWENN
- Hungarian (Magyar): FKERES, HA, SZUMHA
- Italian (Italiano): CERCA.VERT, SE, SOMMA.SE
- Norwegian (Norsk): FINN.RAD, HVIS, SUMMERHVIS
- Portuguese (Brazil) (Português (Brasil)): PROCV, SE, SOMASE
- Portuguese (Portugal) (Português (Portugal)): PROCV, SE, SOMA.SE
- Russian (Русский): ВПР, ЕСЛИ, СУММЕСЛИ
- Spanish (Español): BUSCARV, SI, SUMAR.SI
- Swedish (Svenska): LETARAD, OM, SUMMA.OM
- Turkish (Türkçe): DÜŞEYARA, EĞER, ETOPLA