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