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.

EnglishPolishWhat it does
ABSMODUŁ.LICZBYThe absolute value: the number without its sign.
ACCRINTNAL.ODS
ACCRINTMNAL.ODS.WYKUP
ACOSACOSThe angle, in radians, whose cosine is the number.
ACOSHACOSHThe inverse hyperbolic cosine of a number.
ACOTACOTThe angle, in radians, whose cotangent is the number. The result is between 0 and π.
ACOTHACOTH
ADDRESSADRESBuilds a cell address as text from a row number and a column number.
AGGREGATEAGREGUJLike SUBTOTAL with more calculations, and it can ignore errors in the range.
AMORDEGRCAMORT.NIELIN
AMORLINCAMORT.LIN
ANDORAZTRUE only if every condition is TRUE.
ARABICARABSKIETurns Roman numerals into a number.
AREASOBSZARY
ARRAYTOTEXTTABLICA.NA.TEKSTAll the values of a range written out as one piece of text.
ASINASINThe angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
ASINHASINHThe inverse hyperbolic sine of a number.
ATANATANThe angle, in radians, whose tangent is the number.
ATAN2ATAN2The 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.
ATANHATANHThe inverse hyperbolic tangent of a number.
AVEDEVODCH.ŚREDNIEThe average distance of the values from their mean: a plain measure of how spread out they are.
AVERAGEŚREDNIAThe arithmetic mean of the numbers.
AVERAGEAŚREDNIA.AThe average, counting text in a range as 0 and TRUE as 1.
AVERAGEIFŚREDNIA.JEŻELIAverages the cells that meet a condition.
AVERAGEIFSŚREDNIA.WARUNKÓWAverages the cells that meet every one of several conditions.
BAHTTEXTBAT.TEKST
BASEPODSTAWAWrites a number in another base, such as binary (2) or hexadecimal (16), as text.
BESSELIBESSEL.I
BESSELJBESSEL.J
BESSELKBESSEL.K
BESSELYBESSEL.Y
BETA.DISTROZKŁ.BETAThe beta distribution, for shares and percentages that vary between two bounds.
BETA.INVROZKŁ.BETA.ODWRThe value below which a given share of a beta distribution falls.
BETADISTROZKŁAD.BETAThe chance of x or less in a beta distribution. The older form of BETA.DIST.
BETAINVROZKŁAD.BETA.ODW
BIN2DECDWÓJK.NA.DZIESTurns a binary number into an ordinary one.
BIN2HEXDWÓJK.NA.SZESN
BIN2OCTDWÓJK.NA.ÓSM
BINOM.DISTROZKŁ.DWUMThe chance of a number of successes in a set number of tries, each with the same chance.
BINOM.DIST.RANGEROZKŁ.DWUM.ZAKRESThe chance that the number of successes in a set of tries lands between two counts.
BINOM.INVROZKŁ.DWUM.ODWRThe smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
BINOMDISTROZKŁAD.DWUM
BITANDBITANDCompares two whole numbers bit by bit and keeps the bits that are set in both.
BITLSHIFTBIT.PRZESUNIĘCIE.W.LEWOMoves the bits of a whole number to the left, which doubles it for every bit moved.
BITORBITORCompares two whole numbers bit by bit and keeps the bits that are set in either.
BITRSHIFTBIT.PRZESUNIĘCIE.W.PRAWOMoves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
BITXORBITXORCompares two whole numbers bit by bit and keeps the bits that are set in one but not the other.
CEILINGZAOKR.W.GÓRĘRounds a number up to the nearest multiple (away from zero when both are negative).
CEILING.MATHZAOKR.W.GÓRĘ.MATEMATYCZNERounds a number up to the nearest multiple; mode rounds negative numbers away from zero.
CEILING.PRECISEZAOKR.W.GÓRĘ.DOKŁ
CELLKOMÓRKATells you something about a cell: its address, row, column, contents, number format or the type of value in it.
CHARZNAKThe character for a character code.
CHIDISTROZKŁAD.CHI
CHIINVROZKŁAD.CHI.ODW
CHISQ.DISTROZKŁ.CHIThe chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
CHISQ.DIST.RTROZKŁ.CHI.PSThe 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.INVROZKŁ.CHI.ODWRThe value below which a given share of the chi-square distribution falls.
CHISQ.INV.RTROZKŁ.CHI.ODWR.PSThe chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
CHISQ.TESTCHI.TESTThe chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.
CHITESTTEST.CHI
CHOOSEWYBIERZPicks a value from a list by its position.
CHOOSECOLSWYBIERZ.KOLUMNYReturns the columns you name from an array, in the order you name them.
CLEANOCZYŚĆRemoves non-printable characters.
CODEKODThe character code of the first character.
COLUMNNR.KOLUMNYThe column number of a reference (A = 1).
COLUMNSLICZBA.KOLUMNHow many columns a range has.
COMBINKOMBINACJEHow many ways to choose a number of items from a group, when the order does not matter.
COMBINAKOMBINACJE.AThe number of ways to choose items when the same item may be chosen more than once and the order does not matter.
COMPLEXLICZBA.ZESP
CONCATZŁĄCZ.TEKSTJoins text from several values or ranges.
CONCATENATEZŁĄCZ.TEKSTYJoins several text values (older version of CONCAT).
CONFIDENCEUFNOŚĆ
CONFIDENCE.NORMUFNOŚĆ.NORMThe margin of error for an average: add and subtract it to get the confidence interval.
CONFIDENCE.TUFNOŚĆ.TThe 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.
CONVERTKONWERTUJConverts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.
CORRELWSP.KORELACJIThe correlation coefficient of two data sets: from −1 (opposite) through 0 (unrelated) to 1 (move together).
COSCOSThe cosine of an angle given in radians.
COSHCOSHThe hyperbolic cosine of a number.
COTCOTThe cotangent of an angle: 1 divided by its tangent.
COTHCOTH
COUNTILE.LICZBCounts cells that contain numbers.
COUNTAILE.NIEPUSTYCHCounts cells that are not empty.
COUNTBLANKLICZ.PUSTECounts empty cells in a range.
COUNTIFLICZ.JEŻELICounts the cells that meet a condition.
COUNTIFSLICZ.WARUNKICounts the rows that meet every one of several conditions.
COUPDAYBSWYPŁ.DNI.OD.POCZ
COUPDAYSWYPŁ.DNI
COUPDAYSNCWYPŁ.DNI.NAST
COUPNCDWYPŁ.DATA.NAST
COUPNUMWYPŁ.LICZBA
COUPPCDWYPŁ.DATA.POPRZ
COVARKOWARIANCJA
COVARIANCE.PKOWARIANCJA.POPULPopulation covariance: the average product of the deviations of each pair from their means.
COVARIANCE.SKOWARIANCJA.PRÓBKISample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
CRITBINOMPRÓG.ROZKŁAD.DWUM
CSCCSCThe cosecant of an angle: 1 divided by its sine.
CSCHCSCH
CUBEKPIMEMBERELEMENT.KPI.MODUŁU
CUBEMEMBERELEMENT.MODUŁU
CUBEMEMBERPROPERTYWŁAŚCIWOŚĆ.ELEMENTU.MODUŁU
CUBERANKEDMEMBERUSZEREGOWANY.ELEMENT.MODUŁU
CUBESETZESTAW.MODUŁÓW
CUBESETCOUNTLICZNIK.MODUŁÓW.ZESTAWU
CUBEVALUEWARTOŚĆ.MODUŁU
CUMIPMTSPŁAC.ODSTotal interest paid between two payment numbers.
CUMPRINCSPŁAC.KAPITTotal paid off the loan itself (not interest) between two payment numbers.
DATEDATABuilds a date from a year, month and day.
DATEDIFDATA.RÓŻNICAThe difference between two dates in years, months or days.
DATEVALUEDATA.WARTOŚĆConverts a date written as text into a date serial number.
DAVERAGEBD.ŚREDNIAThe average of a column of a table for the rows that meet conditions written in cells.
DAYDZIEŃThe day of the month (1-31).
DAYSDNIThe number of days between two dates.
DAYS360DNI.360Days between two dates in a year of twelve 30-day months, as some accounts count them.
DBDBDepreciation for one period, losing the same percentage of the remaining value each period.
DCOUNTBD.ILE.REKORDÓWCounts the numbers in a column of a table for the rows that meet conditions written in cells.
DCOUNTABD.ILE.REKORDÓW.ACounts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
DDBDDBDepreciation for one period at double the straight-line rate (or another multiple).
DEC2BINDZIES.NA.DWÓJKWrites a whole number in binary.
DEC2HEXDZIES.NA.SZESNWrites a whole number in hexadecimal.
DEC2OCTDZIES.NA.ÓSM
DECIMALDZIESIĘTNATurns a number written in another base, as text, into an ordinary number.
DEGREESSTOPNIETurns radians into degrees.
DELTACZY.RÓWNETests whether two numbers are equal: 1 when they are, 0 when they are not.
DEVSQODCH.KWADRATOWEThe sum of the squared distances of the values from their mean.
DGETBD.POLEThe 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.
DISCSTOPA.DYSK
DMAXBD.MAXThe largest number in a column of a table among the rows that meet conditions written in cells.
DMINBD.MINThe smallest number in a column of a table among the rows that meet conditions written in cells.
DOLLARKWOTAA number as text in currency style: $1,234.57, with negatives in brackets.
DOLLARDECENA.DZIESTurns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
DOLLARFRCENA.UŁAMTurns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
DPRODUCTBD.ILOCZYNMultiplies the numbers in a column of a table for the rows that meet conditions written in cells.
DROPPOMIŃRemoves the first or last rows or columns of an array.
DSTDEVBD.ODCH.STANDARDThe standard deviation of a column of a table for the matching rows, treating them as a sample.
DSTDEVPBD.ODCH.STANDARD.POPULThe standard deviation of a column of a table for the matching rows, treating them as the whole population.
DSUMBD.SUMAAdds up a column of a table for the rows that meet conditions written in cells.
DVARBD.WARIANCJAThe variance of a column of a table for the matching rows, treating them as a sample.
DVARPBD.WARIANCJA.POPULThe variance of a column of a table for the matching rows, treating them as the whole population.
EDATENR.SER.DATYThe same day a number of months before or after a date.
EFFECTEFEKTYWNAThe yearly rate you really pay or earn, once interest is added several times a year.
ENCODEURLENCODEURLText made safe to put in a web address: spaces become %20, and so on.
EOMONTHNR.SER.OST.DN.MIESThe last day of the month, a number of months away.
ERFFUNKCJA.BŁThe error function between two limits. With one limit it runs from 0.
ERF.PRECISEFUNKCJA.BŁ.DOKŁThe error function from 0 to x.
ERFCKOMP.FUNKCJA.BŁThe complementary error function: 1 - ERF(x).
ERROR.TYPENR.BŁĘDUA number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
EVENZAOKR.DO.PARZRounds away from zero to the next even integer.
EXACTPORÓWNAJTRUE if two text values are exactly the same, including case.
EXPEXPe raised to a power.
EXPANDROZSZERZGrows an array to a set number of rows and columns, filling the new cells.
EXPON.DISTROZKŁ.EXPThe exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
EXPONDISTROZKŁAD.EXP
F.DISTROZKŁ.FThe F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x.
F.DIST.RTROZKŁ.F.PSThe right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic.
F.INVROZKŁ.F.ODWRThe value below which a given share of the F-distribution falls.
F.INV.RTROZKŁ.F.ODWR.PSThe F value with a given share of the distribution above it: the critical value of an F-test.
F.TESTF.TESTThe F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.
FACTSILNIAFactorial: 1 × 2 × … × n.
FACTDOUBLESILNIA.DWUKRThe double factorial: the number times every second whole number below it (7 × 5 × 3 × 1).
FDISTROZKŁAD.F
FILTERXMLFILTERXML
FINDZNAJDŹPosition of one text inside another (case-sensitive).
FINVROZKŁAD.F.ODW
FISHERROZKŁAD.FISHERThe Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested.
FISHERINVROZKŁAD.FISHER.ODWTurns a Fisher-transformed value back into a correlation.
FIXEDZAOKR.DO.TEKSTA number as text, rounded to a set number of decimals, with or without commas.
FLOORZAOKR.W.DÓŁRounds a number down to the nearest multiple (toward zero when both are negative).
FLOOR.MATHZAOKR.W.DÓŁ.MATEMATYCZNERounds a number down to the nearest multiple; mode rounds negative numbers toward zero.
FLOOR.PRECISEZAOKR.W.DÓŁ.DOKŁ
FORECASTREGLINXPredicts a y value for a new x from the best-fit straight line through known data.
FORMULATEXTFORMUŁA.TEKSTShows the formula in a cell as text.
FREQUENCYCZĘ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.
FTESTTEST.F
FVFVThe future value of an investment with regular payments.
FVSCHEDULEWART.PRZYSZŁ.KAPWhat an amount grows to when the interest rate changes from period to period.
GAMMAGAMMAThe gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!
GAMMA.DISTROZKŁ.GAMMAThe gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
GAMMA.INVROZKŁ.GAMMA.ODWRThe value below which a given share of a gamma distribution falls.
GAMMADISTROZKŁAD.GAMMA
GAMMAINVROZKŁAD.GAMMA.ODW
GAMMALNROZKŁAD.LIN.GAMMAThe natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
GAMMALN.PRECISEROZKŁAD.LIN.GAMMA.DOKŁ
GAUSSGAUSSThe chance that a standard normal value falls between the mean and z standard deviations above it.
GCDNAJW.WSP.DZIELGreatest common divisor.
GEOMEANŚREDNIA.GEOMETRYCZNAThe geometric mean: the right average for growth rates.
GESTEPSPRAWDŹ.PRÓGTests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
GETPIVOTDATAWEŹDANETABELIReads one value out of a PivotTable by naming it, so that the formula still finds it when the PivotTable grows or is sorted.
GROWTHREGEXPWValues on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
HARMEANŚREDNIA.HARMONICZNAThe harmonic mean: the right average for rates such as speeds.
HEX2BINSZESN.NA.DWÓJK
HEX2DECSZESN.NA.DZIESTurns a hexadecimal number into an ordinary one.
HEX2OCTSZESN.NA.ÓSM
HLOOKUPWYSZUKAJ.POZIOMOFinds a value in the first row of a table and returns a value from the same column.
HOURGODZINAThe hour of a time (0-23).
HSTACKSTOS.POZPlaces arrays side by side into one wider array.
HYPERLINKHIPERŁĄCZEMakes 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.DISTROZKŁ.HIPERGEOMThe hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
HYPGEOMDISTROZKŁAD.HIPERGEOMThe chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
IFJEŻELIReturns one value if a condition is TRUE and another if it is FALSE.
IFERRORJEŻELI.BŁĄDReturns a fallback value if a formula results in an error.
IFNAJEŻELI.NDReturns a fallback value only for #N/A errors.
IFSWARUNKIChecks conditions in order and returns the value for the first TRUE one.
IMABSMODUŁ.LICZBY.ZESP
IMAGINARYCZ.UROJ.LICZBY.ZESP
IMARGUMENTARG.LICZBY.ZESP
IMCONJUGATESPRZĘŻ.LICZBY.ZESP
IMCOSCOS.LICZBY.ZESP
IMCOSHCOSH.LICZBY.ZESP
IMCOTCOT.LICZBY.ZESP
IMCSCCSC.LICZBY.ZESP
IMCSCHCSCH.LICZBY.ZESP
IMDIVILORAZ.LICZB.ZESP
IMEXPEXP.LICZBY.ZESP
IMLNLN.LICZBY.ZESP
IMLOG10LOG10.LICZBY.ZESP
IMLOG2LOG2.LICZBY.ZESP
IMPOWERPOTĘGA.LICZBY.ZESP
IMPRODUCTILOCZYN.LICZB.ZESP
IMREALCZ.RZECZ.LICZBY.ZESP
IMSECSEC.LICZBY.ZESP
IMSECHSECH.LICZBY.ZESP
IMSINSIN.LICZBY.ZESP
IMSINHSINH.LICZBY.ZESP
IMSQRTPIERWIASTEK.LICZBY.ZESP
IMSUBRÓŻN.LICZB.ZESP
IMSUMSUMA.LICZB.ZESP
IMTANTAN.LICZBY.ZESP
INDEXINDEKSThe value at a given row and column of a range.
INDIRECTADR.POŚRTurns text such as "B2" into a real reference to that cell or range.
INFOINFO
INTZAOKR.DO.CAŁKRounds down to the nearest whole number.
INTERCEPTODCIĘTAWhere the best-fit straight line crosses the y axis: the predicted y when x is 0.
INTRATESTOPA.PROC
IPMTIPMTThe interest part of one loan payment.
IRRIRRInternal rate of return for a series of cash flows.
ISBLANKCZY.PUSTATRUE if the cell is empty.
ISERRCZY.BŁTRUE if the value is any error except #N/A.
ISERRORCZY.BŁĄDTRUE if the value is any error.
ISEVENCZY.PARZYSTETRUE if the number is even.
ISFORMULACZY.FORMUŁATRUE if the cell holds a formula.
ISLOGICALCZY.LOGICZNATRUE if the value is TRUE or FALSE.
ISNACZY.BRAKTRUE if the value is the #N/A error.
ISNONTEXTCZY.NIE.TEKSTTRUE if the value is not text.
ISNUMBERCZY.LICZBATRUE if the value is a number (dates count too).
ISODDCZY.NIEPARZYSTETRUE if the number is odd.
ISOWEEKNUMISO.NUM.TYGThe ISO 8601 week number: weeks start on Monday, and week 1 contains the first Thursday of the year.
ISPMTISPMTThe interest paid in a period of a loan that is repaid in equal amounts of principal, so the interest falls every period.
ISREFCZY.ADRTRUE if the value is a reference to a cell or range.
ISTEXTCZY.TEKSTTRUE if the value is text.
KURTKURTOZAKurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
LARGEMAX.KThe k-th largest value (k = 1 is the maximum).
LCMNAJMN.WSP.WIELLeast common multiple.
LEFTLEWYThe first characters of a text value.
LENDŁThe number of characters in a text value.
LINESTREGLINPFits 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.
LNLNNatural logarithm.
LOGLOGLogarithm to a base (default 10).
LOG10LOG10Base-10 logarithm.
LOGESTREGEXPPFits 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.
LOGINVROZKŁAD.LOG.ODW
LOGNORM.DISTROZKŁ.LOGThe lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
LOGNORM.INVROZKŁ.LOG.ODWRThe value below which a given share of a lognormal distribution falls.
LOGNORMDISTROZKŁAD.LOGThe chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
LOOKUPWYSZUKAJFinds a value in a sorted row or column and returns the value in the same place in another. XLOOKUP is the modern choice.
LOWERLITERY.MAŁEConverts text to lowercase.
MATCHPODAJ.POZYCJĘThe position of a value in a row or column.
MAXMAXThe largest number.
MAXAMAX.AThe largest value, counting text in a range as 0 and TRUE as 1.
MAXIFSMAKS.WARUNKÓWThe largest value among cells that meet conditions.
MDETERMWYZNACZNIK.MACIERZYThe determinant of a square matrix.
MDURATIONROCZ.PRZYCH.M
MEDIANMEDIANAThe middle number of a sorted list.
MIDFRAGMENT.TEKSTUCharacters from the middle of a text value.
MINMINThe smallest number.
MINAMIN.AThe smallest value, counting text in a range as 0 and TRUE as 1.
MINIFSMIN.WARUNKÓWThe smallest value among cells that meet conditions.
MINUTEMINUTAThe minute of a time (0-59).
MINVERSEMACIERZ.ODWThe inverse of a square matrix.
MIRRMIRRRate of return when money borrowed and money reinvested earn different rates.
MMULTMACIERZ.ILOCZYNMultiplies two matrices.
MODMODThe remainder after division.
MODEWYST.NAJCZĘŚCIEJThe most frequently occurring number.
MODE.MULTWYST.NAJCZĘŚCIEJ.TABLEvery value that is tied for most common, as a list.
MODE.SNGLWYST.NAJCZĘŚCIEJ.WART
MONTHMIESIĄCThe month of a date (1-12).
MROUNDZAOKR.DO.WIELOKRRounds to the nearest multiple of a number.
MULTINOMIALWIELOMIANThe 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.
MUNITMACIERZ.JEDNOSTKOWAThe unit matrix of a given size: 1 down the diagonal and 0 everywhere else.
NNConverts a value to a number (text becomes 0).
NABRAKReturns the #N/A error on purpose.
NEGBINOM.DISTROZKŁ.DWUM.PRZECThe negative binomial distribution: the chance of a number of failures before a given number of successes.
NEGBINOMDISTROZKŁAD.DWUM.PRZECThe chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
NETWORKDAYSDNI.ROBOCZEWorking days (Monday–Friday) between two dates, inclusive.
NETWORKDAYS.INTLDNI.ROBOCZE.NIESTANDWorking days between two dates, inclusive, with the weekend on days you choose.
NOMINALNOMINALNAThe quoted yearly rate behind an effective rate. The reverse of EFFECT.
NORM.DISTROZKŁ.NORMALNYThe normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
NORM.INVROZKŁ.NORMALNY.ODWRThe value below which a given share of a normal distribution falls.
NORM.S.DISTROZKŁ.NORMALNY.SThe standard normal distribution (mean 0, standard deviation 1) at a z-score.
NORM.S.INVROZKŁ.NORMALNY.S.ODWRThe z-score below which a given share of the standard normal distribution falls.
NORMDISTROZKŁAD.NORMALNY
NORMINVROZKŁAD.NORMALNY.ODW
NORMSDISTROZKŁAD.NORMALNY.SThe chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
NORMSINVROZKŁAD.NORMALNY.S.ODW
NOTNIEFlips TRUE to FALSE and FALSE to TRUE.
NOWTERAZThe current date and time.
NPERNPERHow many payment periods are needed to pay off a loan.
NPVNPVNet present value of future cash flows at a discount rate.
NUMBERVALUEWARTOŚĆ.LICZBOWATurns text into a number, whatever decimal and thousands marks it uses.
OCT2BINÓSM.NA.DWÓJK
OCT2DECÓSM.NA.DZIES
OCT2HEXÓSM.NA.SZESN
ODDZAOKR.DO.NPARZRounds away from zero to the next odd integer.
ODDFPRICECENA.PIERW.OKR
ODDFYIELDRENT.PIERW.OKR
ODDLPRICECENA.OST.OKR
ODDLYIELDRENT.OST.OKR
OFFSETPRZESUNIĘCIEA range a set number of rows and columns away from a starting cell, of any size.
ORLUBTRUE if at least one condition is TRUE.
PDURATIONO.CZAS.TRWANIAHow many periods an investment needs to reach a target at a steady rate.
PEARSONPEARSONThe Pearson correlation coefficient, the same as CORREL.
PERCENTILEPERCENTYLThe value below which a given percentage of the data falls.
PERCENTILE.EXCPERCENTYL.PRZEDZ.OTWThe value below which a percentage of the data falls, excluding 0% and 100%.
PERCENTILE.INCPERCENTYL.PRZEDZ.ZAMK
PERCENTRANKPROCENT.POZYCJA
PERCENTRANK.EXCPROC.POZ.PRZEDZ.OTWWhere a value stands in a list, between 0 and 1 without ever reaching either.
PERCENTRANK.INCPROC.POZ.PRZEDZ.ZAMKWhere a value stands in a list, from 0 (the lowest) to 1 (the highest).
PERMUTPERMUTACJEHow many ways to pick a number of items from a group, when the order matters.
PERMUTATIONAPERMUTACJE.AThe number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.
PHIPHIThe height of the standard normal bell curve at x.
PIPIThe number π (3.14159…).
PMTPMTThe payment for a loan with constant payments and a constant interest rate.
POISSONROZKŁAD.POISSON
POISSON.DISTROZKŁ.POISSONThe chance of a number of events in a period, given how many happen on average.
POWERPOTĘGARaises a number to a power (same as ^).
PPMTPPMTThe principal (pay-down) part of one loan payment.
PRICECENA
PRICEDISCCENA.DYSK
PRICEMATCENA.WYKUP
PROBPRAWDPDAdds up the probabilities of the outcomes that fall between two limits.
PRODUCTILOCZYNMultiplies all the numbers together.
PROPERZ.WIELKIEJ.LITERYCapitalises The First Letter Of Each Word.
PVPVThe present value: what a series of future payments is worth now.
QUARTILEKWARTYLA quartile of the data (0 = min, 2 = median, 4 = max).
QUARTILE.EXCKWARTYL.PRZEDZ.OTWA quartile of the data (1, 2 or 3), using the exclusive method.
QUARTILE.INCKWARTYL.PRZEDZ.ZAMK
QUOTIENTCZ.CAŁK.DZIELENIAThe whole-number part of a division.
RADIANSRADIANYTurns degrees into radians, which is what SIN, COS and TAN take.
RANDLOSA random number between 0 and 1. Changes on every edit.
RANDARRAYLOSOWA.TABLICAFills an array with random numbers.
RANDBETWEENLOS.ZAKRA random whole number between two limits.
RANKPOZYCJAThe position of a number in a list (1 = largest by default).
RANK.AVGPOZYCJA.ŚRThe position of a number in a list. Tied values share the average of their positions.
RATERATEThe interest rate per period of a loan or investment.
RECEIVEDKWOTA.WYKUP
REPLACEZASTĄPReplaces characters at a given position.
REPTPOWTRepeats text a number of times.
RIGHTPRAWYThe last characters of a text value.
ROMANRZYMSKIEWrites a number in Roman numerals.
ROUNDZAOKRRounds a number to a given number of digits.
ROUNDDOWNZAOKR.DÓŁRounds a number towards zero.
ROUNDUPZAOKR.GÓRARounds a number away from zero.
ROWWIERSZThe row number of a reference (or of the current cell).
ROWSILE.WIERSZYHow many rows a range has.
RRIRÓWNOW.STOPA.PROCThe steady growth rate per period that turns one amount into another (CAGR).
RSQR.KWADRATR squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
RTDDANE.CZASU.RZECZ
SEARCHSZUKAJ.TEKSTPosition of one text inside another (not case-sensitive, allows wildcards).
SECSECThe secant of an angle: 1 divided by its cosine.
SECHSECH
SECONDSEKUNDAThe second of a time (0-59).
SEQUENCESEKWENCJAGenerates a list of sequential numbers that spills into neighbouring cells.
SERIESSUMSUMA.SZER.POTThe sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
SHEETARKUSZThe number of a sheet, counting the tabs from the left: 1 for the first.
SHEETSARKUSZEHow many sheets the workbook has.
SIGNZNAK.LICZBY1 for positive numbers, -1 for negative, 0 for zero.
SINSINThe sine of an angle given in radians.
SINHSINHThe hyperbolic sine of a number.
SKEWSKOŚNOŚĆSkewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
SKEW.PSKOŚNOŚĆ.PHow lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
SLNSLNStraight-line depreciation: the same loss of value every year.
SLOPENACHYLENIEThe slope of the straight line that best fits the data: how much y changes for each 1 added to x.
SMALLMIN.KThe k-th smallest value (k = 1 is the minimum).
SORTSORTUJSorts a range. The result spills.
SORTBYSORTUJ.WEDŁUGSorts a range by the values in another range.
SQRTPIERWIASTEKSquare root.
SQRTPIPIERW.PIThe square root of a number multiplied by π.
STANDARDIZENORMALIZUJA z-score: how many standard deviations a value is above (or below) the mean.
STDEVODCH.STANDARDOWEStandard deviation of a sample.
STDEV.PODCH.STAND.POPULStandard deviation of an entire population.
STDEV.SODCH.STANDARD.PRÓBKI
STDEVAODCH.STANDARDOWE.AThe standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
STDEVPODCH.STANDARD.POPUL
STDEVPAODCH.STANDARD.POPUL.AThe standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
STEYXREGBŁSTDThe standard error of the regression: the typical distance of a y value from the best-fit line.
SUBSTITUTEPODSTAWReplaces specific text with new text.
SUBTOTALSUMY.CZĘŚCIOWETotals a range, leaving out rows that a filter hides and other subtotals inside it.
SUMSUMAAdds up numbers, cells and ranges.
SUMIFSUMA.JEŻELIAdds the cells that meet one condition.
SUMIFSSUMA.WARUNKÓWAdds the cells that meet every one of several conditions.
SUMPRODUCTSUMA.ILOCZYNÓWMultiplies matching items in arrays, then adds the results.
SUMSQSUMA.KWADRATÓWAdds the squares of the numbers.
SUMX2MY2SUMA.X2.M.Y2Adds up the differences of the squares of matching values in two ranges.
SUMX2PY2SUMA.X2.P.Y2Adds up the sums of the squares of matching values in two ranges.
SUMXMY2SUMA.XMY.2Adds up the squares of the differences of matching values in two ranges.
SWITCHPRZEŁĄCZCompares a value against a list and returns the matching result.
SYDSYDSum-of-years’ digits depreciation: more in the early periods, less in the late ones.
TTReturns the value if it is text, otherwise empty text.
T.DISTROZKŁ.TStudent's t-distribution: the chance of a t of x or less, or the height of the curve at x.
T.DIST.2TROZKŁ.T.DSThe 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.RTROZKŁ.T.PSThe right tail of the t-distribution: the chance of a t greater than x.
T.INVROZKŁ.T.ODWRThe t-value below which a given share of the t-distribution falls.
T.INV.2TROZKŁ.T.ODWR.DSThe 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.TESTT.TESTStudent's t-test: the chance that two samples would differ this much if they came from populations with the same mean.
TANTANThe tangent of an angle given in radians.
TANHTANHThe hyperbolic tangent of a number.
TBILLEQRENT.EKW.BS
TBILLPRICECENA.BS
TBILLYIELDRENT.BS
TDISTROZKŁAD.TThe tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T.
TEXTTEKSTFormats a number as text using a format code.
TEXTAFTERTEKST.POThe text that comes after a delimiter.
TEXTBEFORETEKST.PRZEDThe text that comes before a delimiter.
TEXTJOINPOŁĄCZ.TEKSTYJoins text with a separator between each item.
TEXTSPLITPODZIEL.TEKSTSplits text into separate cells at a delimiter. The result spills.
TIMECZASBuilds a time from hours, minutes and seconds.
TIMEVALUECZAS.WARTOŚĆConverts a time written as text into a fraction of a day.
TINVROZKŁAD.T.ODW
TODAYDZIŚToday's date. Updates automatically.
TOROWDO.WIERSZATurns an array into a single row.
TRANSPOSETRANSPONUJFlips rows into columns and columns into rows.
TRENDREGLINWValues on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
TRIMUSUŃ.ZBĘDNE.ODSTĘPYRemoves extra spaces, leaving single spaces between words.
TRIMMEANŚREDNIA.WEWNThe average with a share of the highest and lowest values left out.
TRUNCLICZBA.CAŁKCuts off the decimal part of a number.
TTESTTEST.T
TYPETYPA number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.
UNICHARZNAK.UNICODEThe character with a Unicode number: letters of any alphabet, symbols, emoji.
UNICODEUNICODEThe Unicode number of the first character of some text.
UNIQUEUNIKATOWERemoves duplicates from a list. The result spills.
UPPERLITERY.WIELKIEConverts text to UPPERCASE.
VALUEWARTOŚĆConverts text that looks like a number into a number.
VALUETOTEXTWARTOŚĆ.NA.TEKSTAny value as text. Text passes through unchanged, or in quotes in the strict format.
VARWARIANCJAVariance of a sample.
VAR.PWARIANCJA.POPVariance of an entire population.
VAR.SWARIANCJA.PRÓBKI
VARAWARIANCJA.AThe variance of a sample, counting text and FALSE in a range as 0 and TRUE as 1. VAR skips them.
VARPWARIANCJA.POPUL
VARPAWARIANCJA.POPUL.AThe variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them.
VDBVDBDepreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
VLOOKUPWYSZUKAJ.PIONOWOFinds a value in the first column of a table and returns a value from the same row.
VSTACKSTOS.PIONStacks arrays on top of each other into one taller array.
WEBSERVICEWEBSERVICE
WEEKDAYDZIEŃ.TYGThe day of the week as a number.
WEEKNUMNUM.TYGThe week number of the year.
WEIBULLROZKŁAD.WEIBULL
WEIBULL.DISTROZKŁ.WEIBULLThe Weibull distribution, used for how long things last before they fail.
WORKDAYDZIEŃ.ROBOCZYThe date a number of working days before or after a date.
WORKDAY.INTLDZIEŃ.ROBOCZY.NIESTANDThe date a number of working days before or after a date, with the weekend on days you choose.
WRAPROWSZAWIŃ.WIERSZEWraps a row or column of values into rows of a set length.
XIRRXIRRThe yearly rate of return for cash flows that fall on any dates.
XLOOKUPX.WYSZUKAJSearches a range and returns the matching item from another range. The modern replacement for VLOOKUP.
XMATCHX.DOPASUJThe position of a value in a list, with exact match by default.
XNPVXNPVNet present value of cash flows that fall on any dates, not evenly spaced ones.
XORXORTRUE if an odd number of conditions are TRUE.
YEARROKThe year of a date.
YEARFRACCZĘŚĆ.ROKUThe fraction of a year between two dates, using a day-count basis.
YIELDDISCRENT.DYSK
YIELDMATRENT.WYKUP
Z.TESTZ.TESTThe one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
ZTESTTEST.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