Математические functions
[ ] indicates optional parameters
ABS(число)Returns the absolute value of a number.
| число | The number for which you want the absolute value. |
Returns the angle in radians corresponding to the arccosine of a number.
| число | The number for which you want the arccosine. |
Returns the angle in radians corresponding to the inverse hyperbolic cosine of a number.
| число | The number for which you want the inverse hyperbolic cosine. |
Returns the angle in radians corresponding to the arcsine of a number.
| число | The number for which you want the arcsine. |
Returns the angle in radians corresponding to the inverse hyperbolic sine of a number.
| число | The number for which you want the inverse hyperbolic sine. |
Returns the angle in radians corresponding to the arctangent of a number.
| число | The number for which you want the arctangent. |
Returns the angle in radians corresponding to a pair of co-ordinates.
| x_num | The x co-ordinate for which you want the angle. |
| y_num | The y co-ordinate for which you want the angle. |
Returns the angle in radians corresponding to the inverse hyperbolic tangent of a number.
| число | The number for which you want the inverse hyperbolic tangent. |
Returns the cosine of an angle.
| число | The angle for which you want the cosine. It must be specified in radians. |
Returns the hyperbolic cosine of an angle.
| число | The angle for which you want the hyperbolic cosine. It must be specified in radians. |
Returns the e raised to the power number.
| число | The power to which you want to raise e. |
Returns the natural logarithm of a number.
| число | The number for which you want the natural logarithm. |
LOG(число, [основание_логарифма])
Returns the logarithm of a number in a specified base.
| число | The number for which you want the logarithm. |
| основание_логарифма | The base in which you want the logarithm. If this parameter is omitted it defaults to 10. |
Returns the base 10 logarithm of a number.
| число | The number for which you want the base 10 logarithm. |
Returns the sine of an angle.
| число | The angle for which you want the sine. It must be specified in radians. |
Returns the hyperbolic sine of an angle.
| число | The angle for which you want the hyperbolic sine. It must be specified in radians. |
Returns the tangent of an angle.
| число | The angle for which you want the tangent. It must be specified in radians. |
Returns the hyperbolic tangent of an angle.
| число | The angle for which you want the hyperbolic tangent. It must be specified in radians. |
Converts an angle from radians to degrees.
| угол | The angle that you want to convert. |
Returns the sign of a number; 1 for positive, -1 for negative and 0 for zero.
| число | The number of which you want the sign. |
Returns the square root of a number.
| число | The number of which you want the square root. |
Returns the square root of a number after it is multiplied by Pi.
| число | The number which you want to multiply by Pi and then take the square root. |
Returns the inverse of a matrix.
| массив | An array or reference to cells containing the matrix. |
Returns the determinant of a matrix.
| массив | An array or reference to cells containing the matrix. |
МУЛЬТИНОМ(число1, [число2, ...])
Returns the factorial of the sum of the values divided by the product of their factorials.
| число1, ... | The numbers of which you want the multinomial. |
Returns the product of two matrices.
| массив1 | An array or reference to cells containing the first matrix. |
| массив2 | An array or reference to cells containing the second matrix. |
Returns the number rounded up to the next odd number.
| число | The number which you want rounded. |
Returns the greatest common divisor of a set of numbers.
| число1, ... | The numbers of which you want the greatest common divisor. |
Returns the lowest common multiple of a set of numbers.
| число1, ... | The numbers of which you want the lowest common multiple. |
Returns the number rounded up (away from zero) to the next multiple of significance.
| число | The number which you want rounded. |
| значимость | The units you want to use for rounding. |
Returns the number rounded down (towards zero) to the next multiple of significance.
| число | The number which you want rounded. |
| значимость | The units you want to use for rounding. |
ОКРУГЛ(число, количество_цифр)
Returns a number rounded to the number of decimal places specified.
| число | The number that you want rounded. |
| количество_цифр | The number of decimal places to round to (may be negative). |
ОКРУГЛВВЕРХ(число, [количество_цифр])
Returns a number rounded up to the number of decimal places specified.
| число | The number that you want rounded. |
| количество_цифр | The number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0. |
ОКРУГЛВНИЗ(число, [количество_цифр])
Returns a number rounded down to the number of decimal places specified.
| число | The number that you want rounded. |
| количество_цифр | The number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0. |
Returns the number rounded to a multiple.
| число | The number that you want rounded. |
| multiple | The multiple to which you want the number rounded. |
Returns the remainder of a division.
| число | The dividend. |
| делитель | The divisor. |
ОТБР(число, [количество_цифр])
Returns a number truncated to the number of decimal places specified.
| число | The number that you want truncated. |
| количество_цифр | The number of decimal places to truncate to (may be negative). |
Returns the value of Pi.
ПРОИЗВЕД(число1, [число2, ...])
Returns the product of a list of numbers.
| число1, ... | The numbers that you want to multiply together. |
ПРОМЕЖУТОЧНЫЕ.ИТОГИ(номер_функции, ссылка1, [ссылка2, ...]);
Returns the subtotal of values in one or more ranges, excluding other subtotal figures.
| номер_функции | The subtotal function that you want. The possible values are: | ||||||||||||||||||||||
| |||||||||||||||||||||||
| ссылка1, ... | The ranges of cells that you want subtotalled. |
Converts an angle from degrees to radians.
| угол | The angle that you want to convert. |
Returns a string representing a number converted to roman numerals.
| число | The number that you want to convert. | ||||||||||||||
| форма | Specifies the compactness of the representation. The possible values are: | ||||||||||||||
| |||||||||||||||
| If this parameter is omitted it defaults to 0. |
РЯД.СУММ(x, n, m, coefficients)
Returns the value of a polynomial.
| x | The number to be raised to a power. |
| n | The power of the first term in the series. |
| m | The difference between successive powers in the series. |
| coefficients | An array or reference to cells containing the coefficients. |
СЛУЧМЕЖДУ(наименьшее, наибольшее)
Returns a random integer in the range you specify.
| наименьшее | The lower limit of the range. |
| наибольшее | The upper limit of the range. |
Returns a random number between 0 and 1.
Returns the number raised to the power.
| число | The number which you want raised to a power. |
| степень | The power to which you want to raise the number. |
Returns the sum of a list of numbers.
| число1, ... | The numbers that you want to add together. |
СУММЕСЛИ(диапазон, условие, [диапазон_суммирования])
Returns the sum of cells in a specified range that meet the specified criteria.
| диапазон | A reference to the cells you want to check. |
| условие | A string containing a comparison expression. |
| диапазон_суммирования | A range containing values to be summed where the values in the first range meet the specified criteria. If this parameter is omitted then the values in the first range are summed. |
Returns the sum of the squares of the numbers in the list.
| число1, ... | The numbers that are to be squared and then summed. |
СУММКВРАЗН(массив_x, массив_y)
Returns the sum of the squares of the differences of the numbers in the ranges.
| массив_x | The first range of numbers. |
| массив_y | The second range of numbers. |
СУММПРОИЗВ(массив1, [массив2, ...])
Returns the sum of the products of the cells in one or more ranges.
| массив1, ... | The ranges of cells where corresponding values are multiplied together and then summed. |
СУММРАЗНКВ(массив_x, массив_y)
Returns the sum of the differences of the squares of the numbers in the ranges.
| массив_x | The first range of numbers. |
| массив_y | The second range of numbers. |
СУММСУММКВ(массив_x, массив_y)
Returns the sum of the sums of the squares of the numbers in the ranges.
| массив_x | The first range of numbers. |
| массив_y | The second range of numbers. |
Returns the number of cells in a specified range that meet the specified criteria.
| диапазон | A reference to the cells you want to count. |
| условие | A string containing a comparison expression. |
Returns the factorial of a number.
| число | The number of which you want the factorial. |
Returns the number rounded down to the next integer.
| число | The number which you want rounded. |
Returns the number rounded up to the next even number.
| число | The number which you want rounded. |
ЧАСТНОЕ(numerator, denominator)
Returns the integer result of a division.
| numerator | The dividend. |
| denominator | The divisor. |
ЧИСЛКОМБ(число, выбранное_число)
Returns the number of combinations in which a number of items can be chosen from a total number.
| число | The total number of items. |
| выбранное_число | The number of items chosen. |