Formula translator / Russian

Excel functions in Russian and English

Функции Excel на русском и английском

Excel in Russian has its own name for most functions: VLOOKUP is ВПР and IF is ЕСЛИ. 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")

Russian: =ЕСЛИ(ВПР(A2; Prices!A:C; 3; ЛОЖЬ)>=1,5; "High"; "Low")

In Russian, 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 472 functions in Russian and English

TRUE is ИСТИНА and FALSE is ЛОЖЬ.

EnglishRussianWhat it does
ABSABSThe absolute value: the number without its sign.
ACCRINTНАКОПДОХОД
ACCRINTMНАКОПДОХОДПОГАШ
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
ADDRESSАДРЕСBuilds a cell address as text from a row number and a column number.
AGGREGATEАГРЕГАТLike SUBTOTAL with more calculations, and it can ignore errors in the range.
AMORDEGRCАМОРУМ
AMORLINCАМОРУВ
ANDИTRUE only if every condition is TRUE.
ARABICАРАБСКОЕTurns Roman numerals into a number.
AREASОБЛАСТИ
ARRAYTOTEXTМАССИВВТЕКСТAll 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.
AVEDEVСРОТКЛThe average distance of the values from their mean: a plain measure of how spread out they are.
AVERAGEСРЗНАЧThe arithmetic mean of the numbers.
AVERAGEAСРЗНАЧАThe average, counting text in a range as 0 and TRUE as 1.
AVERAGEIFСРЗНАЧЕСЛИAverages the cells that meet a condition.
AVERAGEIFSСРЗНАЧЕСЛИМНAverages the cells that meet every one of several conditions.
BAHTTEXTБАТТЕКСТ
BASEОСНОВАНИЕWrites a number in another base, such as binary (2) or hexadecimal (16), as text.
BESSELIБЕССЕЛЬ.I
BESSELJБЕССЕЛЬ.J
BESSELKБЕССЕЛЬ.K
BESSELYБЕССЕЛЬ.Y
BETA.DISTБЕТА.РАСПThe beta distribution, for shares and percentages that vary between two bounds.
BETA.INVБЕТА.ОБРThe value below which a given share of a beta distribution falls.
BETADISTБЕТАРАСПThe chance of x or less in a beta distribution. The older form of BETA.DIST.
BETAINVБЕТАОБР
BIN2DECДВ.В.ДЕСTurns a binary number into an ordinary one.
BIN2HEXДВ.В.ШЕСТН
BIN2OCTДВ.В.ВОСЬМ
BINOM.DISTБИНОМ.РАСПThe chance of a number of successes in a set number of tries, each with the same chance.
BINOM.DIST.RANGEБИНОМ.РАСП.ДИАПThe chance that the number of successes in a set of tries lands between two counts.
BINOM.INVБИНОМ.ОБРThe smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
BINOMDISTБИНОМРАСП
BITANDБИТ.ИCompares two whole numbers bit by bit and keeps the bits that are set in both.
BITLSHIFTБИТ.СДВИГЛMoves the bits of a whole number to the left, which doubles it for every bit moved.
BITORБИТ.ИЛИCompares two whole numbers bit by bit and keeps the bits that are set in either.
BITRSHIFTБИТ.СДВИГПMoves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
BITXORБИТ.ИСКЛИЛИCompares two whole numbers bit by bit and keeps the bits that are set in one but not the other.
CEILINGОКРВВЕРХRounds a number up to the nearest multiple (away from zero when both are negative).
CEILING.MATHОКРВВЕРХ.МАТRounds a number up to the nearest multiple; mode rounds negative numbers away from zero.
CEILING.PRECISEОКРВВЕРХ.ТОЧН
CELLЯЧЕЙКАTells you something about a cell: its address, row, column, contents, number format or the type of value in it.
CHARСИМВОЛThe character for a character code.
CHIDISTХИ2РАСП
CHIINVХИ2ОБР
CHISQ.DISTХИ2.РАСПThe chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
CHISQ.DIST.RTХИ2.РАСП.ПХ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ХИ2.ОБРThe value below which a given share of the chi-square distribution falls.
CHISQ.INV.RTХИ2.ОБР.ПХThe chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
CHISQ.TESTХИ2.ТЕСТThe chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.
CHITESTХИ2ТЕСТ
CHOOSEВЫБОРPicks a value from a list by its position.
CHOOSECOLSВЫБОРСТОЛБЦReturns the columns you name from an array, in the order you name them.
CHOOSEROWSВЫБОРСТРОКReturns the rows you name from an array, in the order you name them.
CLEANПЕЧСИМВRemoves non-printable characters.
CODEКОДСИМВThe character code of the first character.
COLUMNСТОЛБЕЦThe column number of a reference (A = 1).
COLUMNSЧИСЛСТОЛБHow many columns a range has.
COMBINЧИСЛКОМБHow many ways to choose a number of items from a group, when the order does not matter.
COMBINAЧИСЛКОМБАThe number of ways to choose items when the same item may be chosen more than once and the order does not matter.
COMPLEXКОМПЛЕКСН
CONCATСЦЕПJoins text from several values or ranges.
CONCATENATEСЦЕПИТЬJoins several text values (older version of CONCAT).
CONFIDENCEДОВЕРИТ
CONFIDENCE.NORMДОВЕРИТ.НОРМThe margin of error for an average: add and subtract it to get the confidence interval.
CONFIDENCE.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ПРЕОБРConverts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.
CORRELКОРРЕЛThe 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
COUNTСЧЁТCounts cells that contain numbers.
COUNTAСЧЁТЗCounts cells that are not empty.
COUNTBLANKСЧИТАТЬПУСТОТЫCounts empty cells in a range.
COUNTIFСЧЁТЕСЛИCounts the cells that meet a condition.
COUNTIFSСЧЁТЕСЛИМНCounts the rows that meet every one of several conditions.
COUPDAYBSДНЕЙКУПОНДО
COUPDAYSДНЕЙКУПОН
COUPDAYSNCДНЕЙКУПОНПОСЛЕ
COUPNCDДАТАКУПОНПОСЛЕ
COUPNUMЧИСЛКУПОН
COUPPCDДАТАКУПОНДО
COVARКОВАР
COVARIANCE.PКОВАРИАЦИЯ.ГPopulation covariance: the average product of the deviations of each pair from their means.
COVARIANCE.SКОВАРИАЦИЯ.ВSample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
CRITBINOMКРИТБИНОМ
CSCCSCThe cosecant of an angle: 1 divided by its sine.
CSCHCSCH
CUBEKPIMEMBERКУБЭЛЕМЕНТКИП
CUBEMEMBERКУБЭЛЕМЕНТ
CUBEMEMBERPROPERTYКУБСВОЙСТВОЭЛЕМЕНТА
CUBERANKEDMEMBERКУБПОРЭЛЕМЕНТ
CUBESETКУБМНОЖ
CUBESETCOUNTКУБЧИСЛОЭЛМНОЖ
CUBEVALUEКУБЗНАЧЕНИЕ
CUMIPMTОБЩПЛАТTotal interest paid between two payment numbers.
CUMPRINCОБЩДОХОДTotal paid off the loan itself (not interest) between two payment numbers.
DATEДАТАBuilds a date from a year, month and day.
DATEDIFРАЗНДАТThe difference between two dates in years, months or days.
DATEVALUEДАТАЗНАЧConverts a date written as text into a date serial number.
DAVERAGEДСРЗНАЧThe average of a column of a table for the rows that meet conditions written in cells.
DAYДЕНЬThe day of the month (1-31).
DAYSДНИThe number of days between two dates.
DAYS360ДНЕЙ360Days between two dates in a year of twelve 30-day months, as some accounts count them.
DBФУОDepreciation for one period, losing the same percentage of the remaining value each period.
DCOUNTБСЧЁТCounts the numbers in a column of a table for the rows that meet conditions written in cells.
DCOUNTAБСЧЁТАCounts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.
DDBДДОБDepreciation for one period at double the straight-line rate (or another multiple).
DEC2BINДЕС.В.ДВWrites a whole number in binary.
DEC2HEXДЕС.В.ШЕСТНWrites a whole number in hexadecimal.
DEC2OCTДЕС.В.ВОСЬМ
DECIMALДЕСTurns a number written in another base, as text, into an ordinary number.
DEGREESГРАДУСЫTurns radians into degrees.
DELTAДЕЛЬТАTests whether two numbers are equal: 1 when they are, 0 when they are not.
DEVSQКВАДРОТКЛThe sum of the squared distances of the values from their mean.
DGETБИЗВЛЕЧЬ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СКИДКА
DMAXДМАКСThe largest number in a column of a table among the rows that meet conditions written in cells.
DMINДМИНThe smallest number in a column of a table among the rows that meet conditions written in cells.
DOLLARРУБЛЬA number as text in currency style: $1,234.57, with negatives in brackets.
DOLLARDEРУБЛЬ.ДЕСTurns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
DOLLARFRРУБЛЬ.ДРОБЬTurns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
DPRODUCTБДПРОИЗВЕДMultiplies the numbers in a column of a table for the rows that meet conditions written in cells.
DROPСБРОСИТЬRemoves the first or last rows or columns of an array.
DSTDEVДСТАНДОТКЛThe standard deviation of a column of a table for the matching rows, treating them as a sample.
DSTDEVPДСТАНДОТКЛПThe standard deviation of a column of a table for the matching rows, treating them as the whole population.
DSUMБДСУММAdds up a column of a table for the rows that meet conditions written in cells.
DVARБДДИСПThe variance of a column of a table for the matching rows, treating them as a sample.
DVARPБДДИСППThe variance of a column of a table for the matching rows, treating them as the whole population.
EDATEДАТАМЕСThe same day a number of months before or after a date.
EFFECTЭФФЕКТThe yearly rate you really pay or earn, once interest is added several times a year.
ENCODEURLКОДИР.URLText made safe to put in a web address: spaces become %20, and so on.
EOMONTHКОНМЕСЯЦАThe last day of the month, a number of months away.
ERFФОШThe error function between two limits. With one limit it runs from 0.
ERF.PRECISEФОШ.ТОЧНThe error function from 0 to x.
ERFCДФОШThe complementary error function: 1 - ERF(x).
ERROR.TYPEТИП.ОШИБКИA number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
EVENЧЁТНRounds away from zero to the next even integer.
EXACTСОВПАДTRUE if two text values are exactly the same, including case.
EXPEXPe raised to a power.
EXPANDРАЗВЕРНУТЬGrows an array to a set number of rows and columns, filling the new cells.
EXPON.DISTЭКСП.РАСПThe exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
EXPONDISTЭКСПРАСП
F.DISTF.РАСП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.RTF.РАСП.ПХ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.INVF.ОБРThe value below which a given share of the F-distribution falls.
F.INV.RTF.ОБР.ПХThe F value with a given share of the distribution above it: the critical value of an F-test.
F.TESTF.ТЕСТThe F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.
FACTФАКТРFactorial: 1 × 2 × … × n.
FACTDOUBLEДВФАКТРThe double factorial: the number times every second whole number below it (7 × 5 × 3 × 1).
FDISTFРАСП
FILTERФИЛЬТРKeeps only the rows that meet a condition. The result spills.
FINDНАЙТИPosition of one text inside another (case-sensitive).
FINVFРАСПОБР
FISHERФИШЕРThe Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested.
FISHERINVФИШЕРОБРTurns a Fisher-transformed value back into a correlation.
FIXEDФИКСИРОВАННЫЙA number as text, rounded to a set number of decimals, with or without commas.
FLOORОКРВНИЗRounds a number down to the nearest multiple (toward zero when both are negative).
FLOOR.MATHОКРВНИЗ.МАТRounds a number down to the nearest multiple; mode rounds negative numbers toward zero.
FLOOR.PRECISEОКРВНИЗ.ТОЧН
FORECASTПРЕДСКАЗPredicts a y value for a new x from the best-fit straight line through known data.
FORMULATEXTФ.ТЕКСТShows the formula in a cell as text.
FREQUENCYЧАСТОТА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ФТЕСТ
FVБСThe future value of an investment with regular payments.
FVSCHEDULEБЗРАСПИСWhat an amount grows to when the interest rate changes from period to period.
GAMMAГАММАThe gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!
GAMMA.DISTГАММА.РАСПThe gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.
GAMMA.INVГАММА.ОБРThe value below which a given share of a gamma distribution falls.
GAMMADISTГАММАРАСП
GAMMAINVГАММАОБР
GAMMALNГАММАНЛОГThe natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
GAMMALN.PRECISEГАММАНЛОГ.ТОЧН
GAUSSГАУССThe chance that a standard normal value falls between the mean and z standard deviations above it.
GCDНОДGreatest common divisor.
GEOMEANСРГЕОМThe geometric mean: the right average for growth rates.
GESTEPПОРОГTests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
GETPIVOTDATAПОЛУЧИТЬ.ДАННЫЕ.СВОДНОЙ.ТАБЛИЦЫ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РОСТValues on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
HARMEANСРГАРМThe harmonic mean: the right average for rates such as speeds.
HEX2BINШЕСТН.В.ДВ
HEX2DECШЕСТН.В.ДЕСTurns a hexadecimal number into an ordinary one.
HEX2OCTШЕСТН.В.ВОСЬМ
HLOOKUPГПРFinds a value in the first row of a table and returns a value from the same column.
HOURЧАСThe hour of a time (0-23).
HSTACKГСТОЛБИКPlaces arrays side by side into one wider array.
HYPERLINKГИПЕРССЫЛКА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ГИПЕРГЕОМ.РАСПThe hypergeometric distribution: the chance of a number of successes in a sample drawn without putting anything back.
HYPGEOMDISTГИПЕРГЕОМЕТThe chance of exactly a number of successes in a sample drawn without putting anything back. The older form of HYPGEOM.DIST.
IFЕСЛИReturns one value if a condition is TRUE and another if it is FALSE.
IFERRORЕСЛИОШИБКАReturns a fallback value if a formula results in an error.
IFNAЕСНДReturns a fallback value only for #N/A errors.
IFSУСЛОВИЯChecks conditions in order and returns the value for the first TRUE one.
IMABSМНИМ.ABS
IMAGINARYМНИМ.ЧАСТЬ
IMARGUMENTМНИМ.АРГУМЕНТ
IMCONJUGATEМНИМ.СОПРЯЖ
IMCOSМНИМ.COS
IMCOSHМНИМ.COSH
IMCOTМНИМ.COT
IMCSCМНИМ.CSC
IMCSCHМНИМ.CSCH
IMDIVМНИМ.ДЕЛ
IMEXPМНИМ.EXP
IMLNМНИМ.LN
IMLOG10МНИМ.LOG10
IMLOG2МНИМ.LOG2
IMPOWERМНИМ.СТЕПЕНЬ
IMPRODUCTМНИМ.ПРОИЗВЕД
IMREALМНИМ.ВЕЩ
IMSECМНИМ.SEC
IMSECHМНИМ.SECH
IMSINМНИМ.SIN
IMSINHМНИМ.SINH
IMSQRTМНИМ.КОРЕНЬ
IMSUBМНИМ.РАЗН
IMSUMМНИМ.СУММ
IMTANМНИМ.TAN
INDEXИНДЕКСThe value at a given row and column of a range.
INDIRECTДВССЫЛTurns text such as "B2" into a real reference to that cell or range.
INFOИНФОРМ
INTЦЕЛОЕRounds down to the nearest whole number.
INTERCEPTОТРЕЗОКWhere the best-fit straight line crosses the y axis: the predicted y when x is 0.
INTRATEИНОРМА
IPMTПРПЛТThe interest part of one loan payment.
IRRВСДInternal rate of return for a series of cash flows.
ISBLANKЕПУСТОTRUE if the cell is empty.
ISERRЕОШTRUE if the value is any error except #N/A.
ISERRORЕОШИБКАTRUE if the value is any error.
ISEVENЕЧЁТНTRUE if the number is even.
ISFORMULAЕФОРМУЛАTRUE if the cell holds a formula.
ISLOGICALЕЛОГИЧTRUE if the value is TRUE or FALSE.
ISNAЕНДTRUE if the value is the #N/A error.
ISNONTEXTЕНЕТЕКСТTRUE if the value is not text.
ISNUMBERЕЧИСЛОTRUE if the value is a number (dates count too).
ISODDЕНЕЧЁТTRUE if the number is odd.
ISOWEEKNUMНОМНЕДЕЛИ.ISOThe ISO 8601 week number: weeks start on Monday, and week 1 contains the first Thursday of the year.
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ЕССЫЛКАTRUE if the value is a reference to a cell or range.
ISTEXTЕТЕКСТTRUE if the value is text.
KURTЭКСЦЕССKurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
LARGEНАИБОЛЬШИЙThe k-th largest value (k = 1 is the maximum).
LCMНОКLeast common multiple.
LEFTЛЕВСИМВThe first characters of a text value.
LENДЛСТРThe number of characters in a text value.
LINESTЛИНЕЙН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.
LNLNNatural logarithm.
LOGLOGLogarithm to a base (default 10).
LOG10LOG10Base-10 logarithm.
LOGESTЛГРФПРИБЛ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ЛОГНОРМОБР
LOGNORM.DISTЛОГНОРМ.РАСПThe lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
LOGNORM.INVЛОГНОРМ.ОБРThe value below which a given share of a lognormal distribution falls.
LOGNORMDISTЛОГНОРМРАСПThe chance of x or less in a lognormal distribution. The older form of LOGNORM.DIST.
LOOKUPПРОСМОТР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СТРОЧНConverts text to lowercase.
MATCHПОИСКПОЗThe position of a value in a row or column.
MAXМАКСThe largest number.
MAXAМАКСАThe largest value, counting text in a range as 0 and TRUE as 1.
MAXIFSМАКСЕСЛИThe largest value among cells that meet conditions.
MDETERMМОПРЕДThe determinant of a square matrix.
MDURATIONМДЛИТ
MEDIANМЕДИАНАThe middle number of a sorted list.
MIDПСТРCharacters from the middle of a text value.
MINМИНThe smallest number.
MINAМИНАThe smallest value, counting text in a range as 0 and TRUE as 1.
MINIFSМИНЕСЛИThe smallest value among cells that meet conditions.
MINUTEМИНУТЫThe minute of a time (0-59).
MINVERSEМОБРThe inverse of a square matrix.
MIRRМВСДRate of return when money borrowed and money reinvested earn different rates.
MMULTМУМНОЖMultiplies two matrices.
MODОСТАТThe remainder after division.
MODEМОДАThe most frequently occurring number.
MODE.MULTМОДА.НСКEvery value that is tied for most common, as a list.
MODE.SNGLМОДА.ОДН
MONTHМЕСЯЦThe month of a date (1-12).
MROUNDОКРУГЛТRounds to the nearest multiple of a number.
MULTINOMIALМУЛЬТИНОМ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МЕДИНThe unit matrix of a given size: 1 down the diagonal and 0 everywhere else.
NЧConverts a value to a number (text becomes 0).
NAНДReturns the #N/A error on purpose.
NEGBINOM.DISTОТРБИНОМ.РАСПThe negative binomial distribution: the chance of a number of failures before a given number of successes.
NEGBINOMDISTОТРБИНОМРАСПThe chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
NETWORKDAYSЧИСТРАБДНИWorking days (Monday–Friday) between two dates, inclusive.
NETWORKDAYS.INTLЧИСТРАБДНИ.МЕЖДWorking days between two dates, inclusive, with the weekend on days you choose.
NOMINALНОМИНАЛThe quoted yearly rate behind an effective rate. The reverse of EFFECT.
NORM.DISTНОРМ.РАСПThe normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
NORM.INVНОРМ.ОБРThe value below which a given share of a normal distribution falls.
NORM.S.DISTНОРМ.СТ.РАСПThe standard normal distribution (mean 0, standard deviation 1) at a z-score.
NORM.S.INVНОРМ.СТ.ОБРThe z-score below which a given share of the standard normal distribution falls.
NORMDISTНОРМРАСП
NORMINVНОРМОБР
NORMSDISTНОРМСТРАСПThe chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
NORMSINVНОРМСТОБР
NOTНЕFlips TRUE to FALSE and FALSE to TRUE.
NOWТДАТАThe current date and time.
NPERКПЕРHow many payment periods are needed to pay off a loan.
NPVЧПСNet present value of future cash flows at a discount rate.
NUMBERVALUEЧЗНАЧTurns text into a number, whatever decimal and thousands marks it uses.
OCT2BINВОСЬМ.В.ДВ
OCT2DECВОСЬМ.В.ДЕС
OCT2HEXВОСЬМ.В.ШЕСТН
ODDНЕЧЁТRounds away from zero to the next odd integer.
ODDFPRICEЦЕНАПЕРВНЕРЕГ
ODDFYIELDДОХОДПЕРВНЕРЕГ
ODDLPRICEЦЕНАПОСЛНЕРЕГ
ODDLYIELDДОХОДПОСЛНЕРЕГ
OFFSETСМЕЩA range a set number of rows and columns away from a starting cell, of any size.
ORИЛИTRUE if at least one condition is TRUE.
PDURATIONПДЛИТHow many periods an investment needs to reach a target at a steady rate.
PEARSONPEARSONThe Pearson correlation coefficient, the same as CORREL.
PERCENTILEПЕРСЕНТИЛЬThe value below which a given percentage of the data falls.
PERCENTILE.EXCПРОЦЕНТИЛЬ.ИСКЛThe value below which a percentage of the data falls, excluding 0% and 100%.
PERCENTILE.INCПРОЦЕНТИЛЬ.ВКЛ
PERCENTRANKПРОЦЕНТРАНГ
PERCENTRANK.EXCПРОЦЕНТРАНГ.ИСКЛWhere a value stands in a list, between 0 and 1 without ever reaching either.
PERCENTRANK.INCПРОЦЕНТРАНГ.ВКЛWhere a value stands in a list, from 0 (the lowest) to 1 (the highest).
PERMUTПЕРЕСТHow many ways to pick a number of items from a group, when the order matters.
PERMUTATIONAПЕРЕСТАThe number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.
PHIФИThe height of the standard normal bell curve at x.
PIПИThe number π (3.14159…).
PMTПЛТThe payment for a loan with constant payments and a constant interest rate.
POISSONПУАССОН
POISSON.DISTПУАССОН.РАСПThe chance of a number of events in a period, given how many happen on average.
POWERСТЕПЕНЬRaises a number to a power (same as ^).
PPMTОСПЛТThe principal (pay-down) part of one loan payment.
PRICEЦЕНА
PRICEDISCЦЕНАСКИДКА
PRICEMATЦЕНАПОГАШ
PROBВЕРОЯТНОСТЬAdds up the probabilities of the outcomes that fall between two limits.
PRODUCTПРОИЗВЕДMultiplies all the numbers together.
PROPERПРОПНАЧCapitalises The First Letter Of Each Word.
PVПСThe present value: what a series of future payments is worth now.
QUARTILEКВАРТИЛЬA quartile of the data (0 = min, 2 = median, 4 = max).
QUARTILE.EXCКВАРТИЛЬ.ИСКЛA quartile of the data (1, 2 or 3), using the exclusive method.
QUARTILE.INCКВАРТИЛЬ.ВКЛ
QUOTIENTЧАСТНОЕThe whole-number part of a division.
RADIANSРАДИАНЫTurns degrees into radians, which is what SIN, COS and TAN take.
RANDСЛЧИСA random number between 0 and 1. Changes on every edit.
RANDBETWEENСЛУЧМЕЖДУA random whole number between two limits.
RANKРАНГThe position of a number in a list (1 = largest by default).
RANK.AVGРАНГ.СРThe position of a number in a list. Tied values share the average of their positions.
RATEСТАВКАThe interest rate per period of a loan or investment.
RECEIVEDПОЛУЧЕНО
REPLACEЗАМЕНИТЬReplaces characters at a given position.
REPTПОВТОРRepeats text a number of times.
RIGHTПРАВСИМВThe last characters of a text value.
ROMANРИМСКОЕWrites a number in Roman numerals.
ROUNDОКРУГЛRounds a number to a given number of digits.
ROUNDDOWNОКРУГЛВНИЗRounds a number towards zero.
ROUNDUPОКРУГЛВВЕРХRounds a number away from zero.
ROWСТРОКАThe row number of a reference (or of the current cell).
ROWSЧСТРОКHow many rows a range has.
RRIЭКВ.СТАВКАThe steady growth rate per period that turns one amount into another (CAGR).
RSQКВПИРСОНR squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
RTDДРВ
SEARCHПОИСКPosition of one text inside another (not case-sensitive, allows wildcards).
SECSECThe secant of an angle: 1 divided by its cosine.
SECHSECH
SECONDСЕКУНДЫThe second of a time (0-59).
SEQUENCEПОСЛЕДОВGenerates a list of sequential numbers that spills into neighbouring cells.
SERIESSUMРЯД.СУММThe sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
SHEETЛИСТThe number of a sheet, counting the tabs from the left: 1 for the first.
SHEETSЛИСТЫHow many sheets the workbook has.
SIGNЗНАК1 for positive numbers, -1 for negative, 0 for zero.
SINSINThe sine of an angle given in radians.
SINHSINHThe hyperbolic sine of a number.
SKEWСКОСSkewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
SKEW.PСКОС.ГHow lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
SLNАПЛStraight-line depreciation: the same loss of value every year.
SLOPEНАКЛОНThe slope of the straight line that best fits the data: how much y changes for each 1 added to x.
SMALLНАИМЕНЬШИЙThe k-th smallest value (k = 1 is the minimum).
SORTСОРТSorts a range. The result spills.
SORTBYСОРТПОSorts a range by the values in another range.
SQRTКОРЕНЬSquare root.
SQRTPIКОРЕНЬПИThe square root of a number multiplied by π.
STANDARDIZEНОРМАЛИЗАЦИЯA z-score: how many standard deviations a value is above (or below) the mean.
STDEVСТАНДОТКЛОНStandard deviation of a sample.
STDEV.PСТАНДОТКЛОН.ГStandard deviation of an entire population.
STDEV.SСТАНДОТКЛОН.В
STDEVAСТАНДОТКЛОНАThe standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.
STDEVPСТАНДОТКЛОНП
STDEVPAСТАНДОТКЛОНПАThe standard deviation of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. STDEVP skips them.
STEYXСТОШYXThe standard error of the regression: the typical distance of a y value from the best-fit line.
SUBSTITUTEПОДСТАВИТЬReplaces specific text with new text.
SUBTOTALПРОМЕЖУТОЧНЫЕ.ИТОГИTotals a range, leaving out rows that a filter hides and other subtotals inside it.
SUMСУММAdds up numbers, cells and ranges.
SUMIFСУММЕСЛИAdds the cells that meet one condition.
SUMIFSСУММЕСЛИМНAdds the cells that meet every one of several conditions.
SUMPRODUCTСУММПРОИЗВMultiplies matching items in arrays, then adds the results.
SUMSQСУММКВAdds the squares of the numbers.
SUMX2MY2СУММРАЗНКВAdds up the differences of the squares of matching values in two ranges.
SUMX2PY2СУММСУММКВAdds up the sums of the squares of matching values in two ranges.
SUMXMY2СУММКВРАЗНAdds up the squares of the differences of matching values in two ranges.
SWITCHПЕРЕКЛЮЧCompares a value against a list and returns the matching result.
SYDАСЧSum-of-years’ digits depreciation: more in the early periods, less in the late ones.
TТReturns the value if it is text, otherwise empty text.
T.DISTСТЬЮДЕНТ.РАСПStudent's t-distribution: the chance of a t of x or less, or the height of the curve at x.
T.DIST.2TСТЬЮДЕНТ.РАСП.2Х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СТЬЮДЕНТ.РАСП.ПХThe right tail of the t-distribution: the chance of a t greater than x.
T.INVСТЬЮДЕНТ.ОБРThe t-value below which a given share of the t-distribution falls.
T.INV.2TСТЬЮДЕНТ.ОБР.2Х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СТЬЮДЕНТ.ТЕСТStudent's t-test: the chance that two samples would differ this much if they came from populations with the same mean.
TAKEВЗЯТЬKeeps the first or last rows or columns of an array.
TANTANThe tangent of an angle given in radians.
TANHTANHThe hyperbolic tangent of a number.
TBILLEQРАВНОКЧЕК
TBILLPRICEЦЕНАКЧЕК
TBILLYIELDДОХОДКЧЕК
TDISTСТЬЮДРАСП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ТЕКСТFormats a number as text using a format code.
TEXTAFTERТЕКСТПОСЛЕThe text that comes after a delimiter.
TEXTBEFOREТЕКСТДОThe text that comes before a delimiter.
TEXTJOINОБЪЕДИНИТЬJoins text with a separator between each item.
TIMEВРЕМЯBuilds a time from hours, minutes and seconds.
TIMEVALUEВРЕМЗНАЧConverts a time written as text into a fraction of a day.
TINVСТЬЮДРАСПОБР
TOCOLПОСТОЛБЦTurns an array into a single column.
TODAYСЕГОДНЯToday's date. Updates automatically.
TOROWПОСТРОКTurns an array into a single row.
TRANSPOSEТРАНСПFlips rows into columns and columns into rows.
TRENDТЕНДЕНЦИЯValues on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
TRIMСЖПРОБЕЛЫRemoves extra spaces, leaving single spaces between words.
TRIMMEANУРЕЗСРЕДНЕЕThe average with a share of the highest and lowest values left out.
TRUNCОТБРCuts off the decimal part of a number.
TTESTТТЕСТ
TYPEТИПA number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.
UNICHARЮНИСИМВThe character with a Unicode number: letters of any alphabet, symbols, emoji.
UNICODEUNICODEThe Unicode number of the first character of some text.
UNIQUEУНИКRemoves duplicates from a list. The result spills.
UPPERПРОПИСНConverts text to UPPERCASE.
VALUEЗНАЧЕНConverts text that looks like a number into a number.
VALUETOTEXTЗНАЧЕНИЕВТЕКСТAny value as text. Text passes through unchanged, or in quotes in the strict format.
VARДИСПVariance of a sample.
VAR.PДИСП.ГVariance of an entire population.
VAR.SДИСП.В
VARAДИСПАThe variance of a sample, counting text and FALSE in a range as 0 and TRUE as 1. VAR skips them.
VARPДИСПР
VARPAДИСПРАThe variance of a whole population, counting text and FALSE in a range as 0 and TRUE as 1. VARP skips them.
VDBПУОDepreciation between any two points in an asset’s life, by declining balance that switches to straight-line once that gives more.
VLOOKUPВПРFinds a value in the first column of a table and returns a value from the same row.
VSTACKВСТОЛБИКStacks arrays on top of each other into one taller array.
WEEKDAYДЕНЬНЕДThe day of the week as a number.
WEEKNUMНОМНЕДЕЛИThe week number of the year.
WEIBULLВЕЙБУЛЛ
WEIBULL.DISTВЕЙБУЛЛ.РАСПThe Weibull distribution, used for how long things last before they fail.
WORKDAYРАБДЕНЬThe date a number of working days before or after a date.
WORKDAY.INTLРАБДЕНЬ.МЕЖДThe date a number of working days before or after a date, with the weekend on days you choose.
WRAPCOLSСВЕРНСТОЛБЦWraps a row or column of values into columns of a set length.
WRAPROWSСВЕРНСТРОКWraps a row or column of values into rows of a set length.
XIRRЧИСТВНДОХThe yearly rate of return for cash flows that fall on any dates.
XLOOKUPПРОСМОТРXSearches a range and returns the matching item from another range. The modern replacement for VLOOKUP.
XMATCHПОИСКПОЗXThe position of a value in a list, with exact match by default.
XNPVЧИСТНЗNet present value of cash flows that fall on any dates, not evenly spaced ones.
XORИСКЛИЛИTRUE if an odd number of conditions are TRUE.
YEARГОДThe year of a date.
YEARFRACДОЛЯГОДАThe fraction of a year between two dates, using a day-count basis.
YIELDДОХОД
YIELDDISCДОХОДСКИДКА
YIELDMATДОХОДПОГАШ
Z.TESTZ.ТЕСТThe one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
ZTESTZТЕСТ

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 Russian 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