Заметки сисадмина о интересных вещах из мира IT, инструкции и рецензии. Настраиваем Компьютеры/Сервера/1С/SIP-телефонию в Москве

Список соответствия имен функций в английской и русской версиях Excel

2007-04-26 · Posted in Office
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 upper-left 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 360-day year (twelve 30-day months), which is used in some accounting calculations.
DB ДОБ Returns the depreciation of an asset for a specified period using the fixed-declining 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 double-declining 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 case-sensitive 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 base-2 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 k-th 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 one-row or one-column 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 k-th 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 y-value 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 bond-equivalent 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 date-time 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 y-values 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 double-declining 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 y-coordinates. The arctangent is the angle from the x-axis 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 base-10 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.

One Response

Leave a Reply