Function name 
Russian equivalent 
Description 
ACCRINT 
НАКОПДОХОД 
Returns the accrued interest for a security that pays periodic interest. 
ADDRESS 
АДРЕС 
Returns a reference to a cell as a piece of text. 
AMORDEGRC 
АМОРУМ 
Returns depreciation for each period. 
AMORLINC 
АМОРУВ 
Returns depreciation for each period. 
AND 
И 
Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE. 
AREAS 
ОБЛАСТИ 
Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell. 
AVEDEV 
СРОТКЛ 
Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set. 
AVERAGE 
СРЗНАЧ 
Returns the average (arithmetic mean) of the arguments. 
BIN2DEC 
ДВ.В.ДЕС 
Converts a binary number to decimal. 
BIN2HEX 
ДВ.В.ШЕСТН 
Converts a binary number to hexadecimal. 
BIN2OCT 
ДВ.В.ВОСЬМ 
Converts a binary number to octal. 
BINOMDIST 
БИНОМРАСП 
Returns the individual term binomial distribution probability. 
CEILING 
ОКРВВЕРХ 
Returns number rounded up, away from zero, to the nearest multiple of significance. 
CELL 
ЯЧЕЙКА 
Returns information about the formatting, location, or contents of the upperleft cell in a reference. 
CHAR 
СИМВОЛ 
Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters. 
CHOOSE 
ВЫБОР 
Uses index_num to return a value from the list of value arguments. 
CLEAN 
ПЕЧСИМВ 
Removes all nonprintable characters from text. 
CODE 
КОДСИМВ 
Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer. 
COLUMN 
СТОЛБЕЦ 
Returns the column number of the given reference. 
COLUMNS 
ЧИСЛСТОЛБ 
Returns the column number of the given reference. 
COMPLEX 
КОМПЛЕКСН 
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. 
CONCATENATE 
СЦЕПИТЬ 
Joins several text strings into one text string. 
CONFIDENCE 
ДОВЕРИТ 
Returns the confidence interval for a population mean. 
COUNT 
СЧЁТ 
Counts the number of cells that contain numbers and also numbers within the list of arguments. Use COUNT to get the number of entries in a number field that’s in a range or array of numbers. 
COUNTA 
СЧЁТЗ 
Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array. 
COUNTBLANK 
СЧИТАТЬПУСТОТЫ 
Counts empty cells in a specified range of cells. 
COUNTIF 
СЧЁТЕСЛИ 
Counts the number of cells within a range that meet the given criteria. 
COUPDAYBS 
ДНЕЙКУПОНДО 
Returns the number of days from the beginning of the coupon period to the settlement date. 
COUPDAYS 
ДНЕЙКУПОН 
Returns the number of days in the coupon period that contains the settlement date. 
COUPDAYSNC 
ДНЕЙКУПОНПОСЛЕ 
Returns the number of days from the settlement date to the next coupon date. 
COUPNCD 
ДАТАКУПОНПОСЛЕ 
Returns a number that represents the next coupon date after the settlement date. 
COUPNUM 
ЧИСЛКУПОН 
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. 
COUPPCD 
ДАТАКУПОНДО 
Returns a number that represents the previous coupon date before the settlement date. 
CUMIPMT 
ОБЩПЛАТ 
Returns the cumulative interest paid on a loan between start_period and end_period. 
CUMPRINC 
ОБЩДОХОД 
Returns the cumulative principal paid on a loan between start_period and end_period. 
DATE 
ДАТА 
Returns the sequential serial number that represents a particular date. 
DATEVALUE 
ДАТАЗНАЧ 
Returns the serial number of the date represented by date_text. Use DATEVALUE to convert a date represented by text to a serial number. 
DAVERAGE 
ДСРЗНАЧ 
Averages the values in a column of a list or database that match conditions you specify. 
DAY 
ДЕНЬ 
Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. 
DAYS360 
ДНЕЙ360 
Returns the number of days between two dates based on a 360day year (twelve 30day months), which is used in some accounting calculations. 
DB 
ДОБ 
Returns the depreciation of an asset for a specified period using the fixeddeclining balance method. 
DCOUNT 
БСЧЁТ 
Counts the cells that contain numbers in a column of a list or database that match conditions you specify. 
DCOUNTA 
БСЧЁТА 
Counts the nonblank cells in a column of a list or database that match conditions you specify. 
DDB 
ДДОБ 
Returns the depreciation of an asset for a specified period using the doubledeclining balance method or some other method you specify. 
DEC2BIN 
ДЕС.В.ДВ 
Converts a decimal number to binary. 
DEC2HEX 
ДЕС.В.ШЕСТН 
Converts a decimal number to hexadecimal. 
DEC2OCT 
ДЕС.В.ВОСЬМ 
Converts a decimal number to octal. 
DEGREES 
ГРАДУСЫ 
Converts radians into degrees. 
DELTA 
ДЕЛЬТА 
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. 
DEVSQ 
КВАДРОТКЛ 
Returns the sum of squares of deviations of data points from their sample mean. 
DGET 
БИЗВЛЕЧЬ 
Extracts a single value from a column of a list or database that matches conditions you specify. 
DISC 
СКИДКА 
Returns the discount rate for a security. 
DMAX 
ДМАКС 
Returns the largest number in a column of a list or database that matches conditions you specify. 
DMIN 
ДМИН 
Returns the smallest number in a column of a list or database that matches conditions you specify. 
DOLLAR 
РУБЛЬ 
The function converts a number to text format and applies a currency symbol. The name of the function (and the symbol that it applies) depends upon your language settings. 
DOLLARDE 
РУБЛЬ.ДЕС 
Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. 
DOLLARFR 
РУБЛЬ.ДРОБЬ 
Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction. 
DPRODUCT 
БДПРОИЗВЕД 
Multiplies the values in a column of a list or database that match conditions you specify. 
DSTDEV 
ДСТАНДОТКЛ 
Estimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions you specify. 
DSTDEVP 
ДСТАНДОТКЛП 
Calculates the standard deviation of a population based on the entire population, using the numbers in a column of a list or database that match conditions you specify. 
DSUM 
БДСУММ 
Adds the numbers in a column of a list or database that match conditions you specify. 
DURATION 
ДЛИТ 
Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of the cash flows and is used as a measure of a bond price’s response to changes in yield. 
DVAR 
БДДИСП 
Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions you specify. 
DVARP 
БДДИСПП 
Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions you specify. 
EDATE 
ДАТАМЕС 
Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). 
effect 
ЧИСЛКОМБ 
Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items. 
EFFECT 
ЭФФЕКТ 
Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. 
EOMONTH 
КОНЕЦМЕСЯЦА 
Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. 
ERF 
ФОШ 
Returns the error function integrated between lower_limit and upper_limit. 
ERFC 
ДФОШ 
Returns the complementary ERF function integrated between x and infinity. 
ERROR.TYPE 
ТИП.ОШИБКИ 
Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists. You can use ERROR.TYPE in an IF function to test for an error value and return a text string, such as a message, instead of the error value. 
EVEN 
ЧЁТН 
Returns number rounded up to the nearest even integer. 
EXACT 
СОВПАД 
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is casesensitive but ignores formatting differences. Use EXACT to test text being entered into a document. 
EXPONDIST 
ЭКСПРАСП 
Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. 
FACT 
ФАКТР 
Returns the factorial of a number. The factorial of a number is equal to 1*2*3*…* number. 
FACTDOUBLE 
ДВФАКТР 
Returns the double factorial of a number. 
FIND 
НАЙТИ 
FIND finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text. 
FIXED 
ФИКСИРОВАННЫЙ 
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. 
FLOOR 
ОКРВНИЗ 
Rounds number down, toward zero, to the nearest multiple of significance. 
FREQUENCY 
ЧАСТОТА 
Calculates how often values occur within a range of values, and then returns a vertical array of numbers. 
FVSCHEDULE 
БЗРАСПИС 
Returns the future value of an initial principal after applying a series of compound interest rates. Use FVSCHEDULE to calculate the future value of an investment with a variable or adjustable rate. 
GAMMADIST 
ГАММАРАСП 
Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. 
GAMMAINV 
ГАММАОБР 
Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,…), then GAMMAINV(p,…) = x. 
GAMMALN 
ГАММАНЛОГ 
Returns the natural logarithm of the gamma function, Γ(x). 
GCD 
НОД 
Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder. 
GESTEP 
ПОРОГ 
Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. 
HEX2BIN 
ШЕСТН.В.ДВ 
Converts a hexadecimal number to binary. 
HEX2DEC 
ШЕСТН.В.ДЕС 
Converts a hexadecimal number to decimal. 
HEX2OCT 
ШЕСТН.В.ВОСЬМ 
Converts a hexadecimal number to octal. 
HLOOKUP 
ГПР 
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. 
HOUR 
ЧАС 
Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). 
HYPGEOMDIST 
ГИПЕРГЕОМЕТ 
Returns the hypergeometric distribution. 
IF 
ЕСЛИ 
Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. 
IMABS 
МНИМ.ABS 
Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format. 
IMAGINARY 
МНИМ.ЧАСТЬ 
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. 
IMARGUMENT 
МНИМ.АРГУМЕНТ 
Returns the argument theta that is an argument expressed in radians 
IMCONJUGATE 
МНИМ.СОПРЯЖ 
Returns the complex conjugate of a complex number in x + yi or x + yj text format. 
IMCOS 
МНИМ.COS 
Returns the cosine of a complex number in x + yi or x + yj text format. 
IMDIV 
МНИМ.ДЕЛ 
Returns the quotient of two complex numbers in x + yi or x + yj text format. 
IMEXP 
МНИМ.EXP 
Returns the exponential of a complex number in x + yi or x + yj text format. 
IMLN 
МНИМ.LN 
Returns the natural logarithm of a complex number in x + yi or x + yj text format. 
IMLOG10 
МНИМ.LOG10 
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. 
IMLOG2 
МНИМ.LOG2 
Returns the base2 logarithm of a complex number in x + yi or x + yj text format. 
IMPOWER 
МНИМ.СТЕПЕНЬ 
Returns a complex number in x + yi or x + yj text format raised to a power. 
IMPRODUCT 
МНИМ.ПРОИЗВЕД 
Returns the product of 2 to 29 complex numbers in x + yi or x + yj text format. 
IMREAL 
МНИМ.ВЕЩ 
Returns the real coefficient of a complex number in x + yi or x + yj text format. 

IMSIN 
МНИМ.SIN 
Returns the sine of a complex number in x + yi or x + yj text format. 
IMSQRT 
МНИМ.КОРЕНЬ 
Returns the square root of a complex number in x + yi or x + yj text format. 

IMSUB 
МНИМ.РАЗН 
Returns the difference of two complex numbers in x + yi or x + yj text format. 
IMSUM 
МНИМ.СУММ 
Returns the sum of two or more complex numbers in x + yi or x + yj text format. 
INDEX 
ИНДЕКС 
Returns a value or the reference to a value from within a table or range. 
INDIRECT 
ДВССЫЛ 
Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself. 
INFO 
ИНФОРМ 
Returns information about the current operating environment. 
INT 
ЦЕЛОЕ 
Rounds a number down to the nearest integer. 
INTRATE 
ИНОРМА 
Returns the interest rate for a fully invested security. 
IPMT 
ПЛПРОЦ 
Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. 
IRR 
ВНДОХ 
Returns the internal rate of return for a series of cash flows represented by the numbers in values. 
ISBLANK 
ЕПУСТО 
Value refers to an empty cell. 
ISERR 
ЕОШ 
Value refers to any error value except #N/A. 
ISERROR 
ЕОШИБКА 
Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). 
ISEVEN 
ЕЧЁТН 
Returns TRUE if number is even, or FALSE if number is odd. 
ISLOGICAL 
ЕЛОГИЧ 
This section describes the nine worksheet functions used for testing the type of a value or reference. 
ISNA 
ЕНД 
This section describes the nine worksheet functions used for testing the type of a value or reference. 
ISNONTEXT 
ЕНЕТЕКСТ 
Value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.) 
ISNUMBER 
ЕЧИСЛО 
Value refers to a number. 
ISODD 
ЕНЕЧЁТ 
Returns TRUE if number is odd, or FALSE if number is even. 
ISREF 
ЕССЫЛКА 
Value refers to a reference. 
ISTEXT 
ЕТЕКСТ 
Value refers to text. 
KURT 
ЭКСЦЕСС 
Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution. 
LARGE 
НАИБОЛЬШИЙ 
Returns the kth largest value in a data set. You can use this function to select a value based on its relative standing. 
LCM 
НОК 
Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators. 
LEFT 
ЛЕВСИМВ 
LEFT returns the first character or characters in a text string, based on the number of characters you specify. 
LEN 
ДЛСТР 
LEN returns the number of characters in a text string. 
LINEST 
ЛИНЕЙН 
Calculates the statistics for a line by using the “least squares” method to calculate a straight line that best fits your data, and returns an array that describes the line. Because this function returns an array of values, it must be entered as an array formula. 
LOGEST 
ЛГРФПРИБЛ 
In regression analysis, calculates an exponential curve that fits your data and returns an array of values that describes the curve. Because this function returns an array of values, it must be entered as an array formula. 
LOOKUP 
ПРОСМОТР 
Returns a value either from a onerow or onecolumn range or from an array. 
LOWER 
СТРОЧН 
Converts all uppercase letters in a text string to lowercase. 
MATCH 
ПОИСКПОЗ 
Returns the relative position of an item in an array that matches a specified value in a specified order. 
MAX 
МАКС 
Returns the largest value in a set of values. 
MDETERM 
МОПРЕД 
Returns the matrix determinant of an array. 
MEDIAN 
МЕДИАНА 
Returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less. 
MID 
ПСТР 
MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. 
MIN 
МИН 
Returns the smallest number in a set of values. 
MINUTE 
МИНУТЫ 
Returns the minutes of a time value. The minute is given as an integer, ranging from 0 to 59. 
MINVERSE 
МОБР 
Returns the inverse matrix for the matrix stored in an array. 
MIRR 
ИВСД 
Returns the modified internal rate of return for a series of periodic cash flows. 
MMULT 
МУМНОЖ 
Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. 
MOD 
ОСТАТ 
Returns the remainder after number is divided by divisor. The result has the same sign as divisor. 
MONTH 
МЕСЯЦ 
Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December). 
MROUND 
ОКРУГЛТ 
Returns a number rounded to the desired multiple. 
N 
Ч 
Returns a value converted to a number. 
NA 
НД 
Returns the error value #N/A. #N/A is the error value that means “no value is available.” 
NETWORKDAYS 
ЧИСТРАБДНИ 
Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. 
NOMINAL 
НОМИНАЛ 
Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year. 
NOT 
НЕ 
Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value. 
NOW 
ТДАТА 
Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. 
NPER 
КПЕР 
Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. 
NPV 
НПЗ 
Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). 
OCT2BIN 
ВОСЬМ.В.ДВ 
Converts an octal number to binary. 
OCT2DEC 
ВОСЬМ.В.ДЕС 
Converts an octal number to decimal. 
OCT2HEX 
ВОСЬМ.В.ШЕСТН 
Converts an octal number to hexadecimal. 
ODD 
НЕЧЁТ 
Returns number rounded up to the nearest odd integer. 
ODDFPRICE 
ЦЕНАПЕРНЕРЕГ 
Returns the price per $100 face value of a security having an odd (short or long) first period. 
ODDFYIELD 
ДОХОДПЕРВНЕРЕГ 
Returns the yield of a security that has an odd (short or long) first period. 
ODDLPRICE 
ЦЕНАПОСЛНЕРЕГ 
Returns the price per $100 face value of a security having an odd (short or long) last coupon period. 
ODDLYIELD 
ДОХОДПОСЛНЕРЕГ 
Returns the yield of a security that has an odd (short or long) last period. 
OFFSET 
СМЕЩ 
Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. 
OR 
ИЛИ 
Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE. 
PERCENTRANK 
ПРОЦЕНТРАНГ 
Returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set. 
PERMUT 
ПЕРЕСТ 
Returns the number of permutations for a given number of objects that can be selected from number objects. 
PI 
ПИ 
Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits. 
PMT 
ППЛАТ 
Calculates the payment for a loan based on constant payments and a constant interest rate. 
POWER 
СТЕПЕНЬ 
Returns the result of a number raised to a power. 
PPMT 
ОСНПЛАТ 
Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. 
PRICE 
ЦЕНА 
Returns the price per $100 face value of a security that pays periodic interest. 
PRICEDISC 
ЦЕНАСКИДКА 
Returns the price per $100 face value of a discounted security. 
PRICEMAT 
ЦЕНАПОГАШ 
Returns the price per $100 face value of a security that pays interest at maturity. 
PROB 
ВЕРОЯТНОСТЬ 
Returns the probability that values in a range are between two limits. 
PRODUCT 
ПРОИЗВЕД 
Multiplies all the numbers given as arguments and returns the product. 
PV 
ПЗ 
Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. For example, when 
QUOTIENT 
ЧАСТНОЕ 
Returns the integer portion of a division. Use this function when you want to discard the remainder of a division. 
RADIANS 
РАДИАНЫ 
Converts degrees to radians. 
RAND 
СЛЧИС 
Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated. 
RANDBETWEEN 
СЛУЧМЕЖДУ 
Returns a random number between the numbers you specify. A new random number is returned every time the worksheet is calculated. 
RANK 
РАНГ 
Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. 
RATE 
НОРМА 
Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. 
RECEIVED 
ПОЛУЧЕНО 
Returns the amount received at maturity for a fully invested security. 
REPLACE 
ЗАМЕНИТЬ 
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. 
REPT 
ПОВТОР 
Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. 
RIGHT 
ПРАВСИМВ 
RIGHT returns the last character or characters in a text string, based on the number of characters you specify. 
ROMAN 
РИМСКОЕ 
Converts an arabic numeral to roman, as text. 
ROUND 
ОКРУГЛ 
Rounds a number to a specified number of digits. 
ROUNDDOWN 
ОКРУГЛВНИЗ 
Rounds a number down, toward zero. 
ROUNDUP 
ОКРУГЛВВЕРХ 
Rounds a number up, away from 0 (zero). 
ROW 
СТРОКА 
Returns the row number of a reference. 
ROWS 
ЧСТРОК 
Returns the number of rows in a reference or array. 
SEARCH 
ПОИСК 
SEARCH returns the number of the character at which a specific character or text string is first found, beginning with start_num. 
SECOND 
СЕКУНДЫ 
Returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59. 
SERIESSUM 
РЯД.СУМ 
Returns the sum of a power series. 
SIGN 
ЗНАК 
Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and 1 if the number is negative. 
SLOPE 
НАКЛОН 
Returns the slope of the linear regression line through data points in known_y’s and known_x’s. 
SMALL 
НАИМЕНЬШИЙ 
Returns the kth smallest value in a data set. Use this function to return values with a particular relative standing in a data set. 
SQRT 
КОРЕНЬ 
Returns a positive square root. 
SQRTPI 
КОРЕНЬПИ 
Returns the square root of (number * pi). 
STANDARDIZE 
НОРМАЛИЗАЦИЯ 
Returns a normalized value from a distribution characterized by mean and standard_dev. 
STDEV 
СТАНДОТКЛОН 
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). 
STEYX 
СТОШYX 
Returns the standard error of the predicted yvalue for each x in the regression. The standard error is a measure of the amount of error in the prediction of y for an individual x. 
SUBSTITUTE 
ПОДСТАВИТЬ 
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string. 
SUBTOTAL 
ПРОМЕЖУТОЧНЫЕ.ИТОГИ 
Returns a subtotal in a list or database. It is generally easier to create a list with subtotals using the Subtotals command (Data menu). Once the subtotal list is created, you can modify it by editing the SUBTOTAL function. 
SUM 
СУММ 
Adds all the numbers in a range of cells. 
SUMIF 
СУММЕСЛИ 
Adds the cells specified by a given criteria. 
SUMPRODUCT 
СУММПРОИЗВ 
Multiplies corresponding components in the given arrays, and returns the sum of those products. 
SUMSQ 
СУММКВ 
Returns the sum of the squares of the arguments. 
SUMX2MY2 
СУММРАЗНКВ 
Returns the sum of the difference of squares of corresponding values in two arrays. 
SUMX2PY2 
СУММСУММКВ 
Returns the sum of the sum of squares of corresponding values in two arrays. The sum of the sum of squares is a common term in many statistical calculations. 
SUMXMY2 
СУММКВРАЗН 
Returns the sum of squares of differences of corresponding values in two arrays. 
SYD 
АМГД 
Returns the annual depreciation for a given period. 
T 
Т 
Returns the text referred to by value. 
TBILLEQ 
РАВНОКЧЕК 
Returns the bondequivalent yield for a Treasury bill. 
TBILLPRICE 
ЦЕНАКЧЕК 
Returns the price per $100 face value for a Treasury bill. 
TBILLYIELD 
ДОХОДЧЕК 
Returns the yield for a Treasury bill. 
TEXT 
ТЕКСТ 
Converts a value to text in a specific number format. 
TIME 
ВРЕМЯ 
Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. 
TIMEVALUE 
ВРЕМЗНАЧ 
Returns the decimal number of the time represented by a text string. 
TODAY 
СЕГОДНЯ 
Returns the serial number of the current date. The serial number is the datetime code used by Microsoft Excel for date and time calculations. 
TRANSPOSE 
ТРАНСП 
Returns a vertical range of cells as a horizontal range, or vice versa. 
TREND 
ТЕНДЕНЦИЯ 
Returns values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y’s and known_x’s. Returns the yvalues along that line for the array of new_x’s that you specify. 
TRIM 
СЖПРОБЕЛЫ 
Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing. 
TRIMMEAN 
УРЕСРЕДНЕЕ 
Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set. 
TRUNC 
ОТБР 
Truncates a number to an integer by removing the fractional part of the number. 
TYPE 
ТИП 
Returns the type of value. Use TYPE when the behavior of another function depends on the type of value in a particular cell. 
UPPER 
ПРОПИСН 
Converts text to uppercase. 
VALUE 
ЗНАЧЕН 
Converts a text string that represents a number to a number. 
VAR 
ДИСП 
Estimates variance based on a sample. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation. 
VARP 
ДИСПР 
Calculates variance based on the entire population. 
VDB 
ПДОБ 
Returns the depreciation of an asset for any period you specify, including partial periods, using the doubledeclining balance method or some other method you specify. VDB stands for variable declining balance. 
VLOOKUP 
ВПР 
Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. 
WEEKDAY 
ДЕНЬНЕД 
Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. 
WORKDAY 
РАБДЕНЬ 
Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). 
XIRR 
ЧИСТВНДОХ 
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the IRR function. 
XNPV 
ЧИСТНЗ 
Returns the net present value for a schedule of cash flows that is not necessarily periodic. To calculate the net present value for a series of cash flows that is periodic, use the NPV function. 
YEAR 
ГОД 
Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups. 
YEARFRAC 
ДОЛЯГОДА 
Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). 
YIELD 
ДОХОД 
Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield. 
YIELDDISC 
ДОХОДСКИДКА 
Returns the annual yield for a discounted security. 
YIELDMAT 
ДОХОДПОГАШ 
Returns the annual yield of a security that pays interest at maturity. 
FALSE 
ЛОЖЬ 
Returns the logical value FALSE. 
TRUE 
ИСТИНА 
Returns the logical value TRUE. 
ABS 

Returns the absolute value of a number. The absolute value of a number is the number without its sign. 
ACOSH 

Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number. 
ACOS 

Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi. 
ASINH 

Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, so ASINH(SINH(number)) equals number. 
ASIN 

Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range pi/2 to pi/2. 
ATAN2 

Returns the arctangent, or inverse tangent, of the specified x and ycoordinates. The arctangent is the angle from the xaxis to a line containing the origin (0, 0) and a point with coordinates (x_num, y_num). The angle is given in radians between pi and pi, excluding pi. 
ATANH 

Returns the inverse hyperbolic tangent of a number. Number must be between 1 and 1 (excluding 1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH(number)) equals number. 
ATAN 

Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range pi/2 to pi/2. 
COSH 

Returns the hyperbolic cosine of a number. 
COS 

Returns the cosine of the given angle. 
EXP 

Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm. 
LN 

Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904). 
LOG10 

Returns the base10 logarithm of a number. 
LOG 

Returns the logarithm of a number to the base you specify. 
SINH 

Returns the hyperbolic sine of a number. 
TANH 

Returns the hyperbolic tangent of a number. 
TAN 

Returns the tangent of the given angle. 