Excel functions

https://functiontranslator.com

## ZTEST

Опубликовано: February 13, 2021 в 11:37 am

Автор:

Категории: Compatibility

Returns the one-tailed probability-value of a z-test.

## Z.TEST

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the one-tailed probability-value of a z-test.

## YIELDMAT

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the annual yield of a security that pays interest at maturity.

## YIELDDISC

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the annual yield for a discounted security; for example, a Treasury bill.

## YIELD

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the yield on a security that pays periodic interest.

## YEARFRAC

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Returns the year fraction representing the number of whole days between start_date and end_date.

## YEAR

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Converts a serial number to a year.

## XOR

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Logical

Returns a logical exclusive OR of all arguments.

## XNPV

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the net present value for a schedule of cash flows that is not necessarily periodic.

## XMATCH

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Returns the relative position of an item in an array or range of cells.

## XLOOKUP

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn’t exist, then XLOOKUP can return the closest (approximate) match.

## XIRR

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

## WORKDAY.INTL

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.

## WORKDAY

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Returns the serial number of the date before or after a specified number of workdays.

## WEIBULL.DIST

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the Weibull distribution.

## WEIBULL

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Calculates variance based on the entire population, including numbers, text, and logical values.

## WEEKNUM

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Converts a serial number to a number representing where the week falls numerically with a year.

## WEEKDAY

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Converts a serial number to a day of the week.

## WEBSERVICE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Web

Returns data from a web service.

## VLOOKUP

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Looks in the first column of an array and moves across the row to return the value of a cell.

## VDB

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the depreciation of an asset for a specified or partial period by using a declining balance method.

## VARPA

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Calculates variance based on the entire population, including numbers, text, and logical values.

## VARP

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Calculates variance based on the entire population.

## VARA

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Estimates variance based on a sample, including numbers, text, and logical values.

## VAR.S

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Estimates variance based on a sample.

## VAR.P

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Calculates variance based on the entire population.

## VAR

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Estimates variance based on a sample.

## VALUETOTEXT

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Returns text from any specified value.

## VALUE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Converts a text argument to a number.

## UPPER

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Converts text to uppercase.

## UNIQUE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Returns a list of unique values in a list or range.

## UNICODE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Returns the number (code point) that corresponds to the first character of the text.

## UNICHAR

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Returns the Unicode character that is references by the given numeric value.

## TYPE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Information

Returns a number indicating the data type of a value.

## TTEST

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Returns the probability associated with a Student’s t-test.

## T.TEST

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the probability associated with a Student’s t-test.

## TRUNC

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Truncates a number to an integer.

## TRUE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Logical

Returns the logical value TRUE.

## TRIMMEAN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the mean of the interior of a data set.

## TRIM

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Removes spaces from text.

## TREND

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns values along a linear trend.

## TRANSPOSE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Returns the transpose of an array.

## TODAY

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Returns the serial number of today’s date.

## TINV

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Returns the inverse of the Student’s t-distribution.

## T.INV.2T

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the inverse of the Student’s t-distribution.

## T.INV

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom.

## TIMEVALUE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Converts a time in the form of text to a serial number.

## TIME

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Returns the serial number of a particular time.

## TEXTJOIN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

## TEXT

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Formats a number and converts it to text.

## TDIST

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Returns the Student’s t-distribution.

## T.DIST.RT

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the Student’s t-distribution.

## T.DIST.2T

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the Percentage Points (probability) for the Student t-distribution.

## T.DIST

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the Percentage Points (probability) for the Student t-distribution.

## TBILLYIELD

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the yield for a Treasury bill.

## TBILLPRICE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the price per \$100 face value for a Treasury bill.

## TBILLEQ

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the bond-equivalent yield for a Treasury bill.

## TANH

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the hyperbolic tangent of a number.

## TAN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the tangent of a number.

## T

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Converts its arguments to text.

## SYD

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the sum-of-years’ digits depreciation of an asset for a specified period.

## SWITCH

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Logical

Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.

## SUMXMY2

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the sum of squares of differences of corresponding values in two arrays.

## SUMX2PY2

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the sum of the sum of squares of corresponding values in two arrays.

## SUMX2MY2

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the sum of the difference of squares of corresponding values in two arrays.

## SUMSQ

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the sum of the squares of the arguments.

## SUMPRODUCT

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the sum of the products of corresponding array components.

## SUMIFS

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Adds the cells in a range that meet multiple criteria.

## SUMIF

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Adds the cells specified by a given criteria.

## SUM

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

## SUBTOTAL

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns a subtotal in a list or database.

## SUBSTITUTE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Substitutes new text for old text in a text string.

## STEYX

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the standard error of the predicted y-value for each x in the regression.

## STDEVPA

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Calculates standard deviation based on the entire population, including numbers, text, and logical values.

## STDEVP

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Calculates standard deviation based on the entire population.

## STDEVA

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Estimates standard deviation based on a sample, including numbers, text, and logical values.

## STDEV.S

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Estimates standard deviation based on a sample.

## STDEV.P

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Calculates standard deviation based on the entire population.

## STDEV

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Estimates standard deviation based on a sample.

## STANDARDIZE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns a normalized value.

## SQRTPI

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the square root of (number * pi).

## SQRT

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns a positive square root.

## SORTBY

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Sorts the contents of a range or array based on the values in a corresponding range or array.

## SORT

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Sorts the contents of a range or array.

## SMALL

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the k-th smallest value in a data set.

## SLOPE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the slope of the linear regression line.

## SLN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the straight-line depreciation of an asset for one period.

## SKEW.P

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.

## SKEW

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the skewness of a distribution.

## SINH

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the hyperbolic sine of a number.

## SIN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the sine of the given angle.

## SIGN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the sign of a number.

## SHEETS

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Information

Returns the number of sheets in a reference.

## SHEET

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Information

Returns the sheet number of the referenced sheet.

## SERIESSUM

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the sum of a power series based on the formula.

## SEQUENCE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Generates a list of sequential numbers in an array, such as 1, 2, 3, 4.

## SECOND

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Date and time

Converts a serial number to a second.

## SECH

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the hyperbolic secant of an angle.

## SEC

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns the secant of an angle.

## SEARCH, SEARCHBs

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Finds one text value within another (not case-sensitive).

## RTD

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Retrieves real-time data from a program that supports COM automation.

## RSQ

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the square of the Pearson product moment correlation coefficient.

## RRI

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns an equivalent interest rate for the growth of an investment.

## ROWS

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Returns the number of rows in a reference.

## ROW

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Lookup and reference

Returns the row number of a reference.

## ROUNDUP

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Rounds a number up, away from zero.

## ROUNDDOWN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Rounds a number down, toward zero.

## ROUND

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Rounds a number to a specified number of digits.

## ROMAN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Converts an arabic numeral to roman, as text.

## RIGHT, RIGHTBs

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Returns the rightmost characters from a text value.

## REPT

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Repeats text a given number of times.

## REPLACE, REPLACEBs

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Text

Replaces characters within text.

## REGISTER.ID

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered.

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the amount received at maturity for a fully invested security.

## RATE

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Financial

Returns the interest rate per period of an annuity.

## RANK

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Compatibility

Returns the rank of a number in a list of numbers.

## RANK.EQ

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the rank of a number in a list of numbers.

## RANK.AVG

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Statistical

Returns the rank of a number in a list of numbers.

## RANDBETWEEN

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns a random number between the numbers you specify.

## RANDARRAY

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.

## RAND

Опубликовано: February 13, 2021 в 11:36 am

Автор:

Категории: Math and trigonometry

Returns a random number between 0 and 1.

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

## QUOTIENT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the integer portion of a division.

## QUARTILE.INC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the quartile of a data set.

## QUARTILE.EXC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the quartile of the data set, based on percentile values from 0.1, exclusive.

## QUARTILE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the quartile of a data set.

## PV

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the present value of an investment.

## PROPER

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Text

Capitalizes the first letter in each word of a text value.

## PRODUCT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Multiplies its arguments.

## PROB

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the probability that values in a range are between two limits.

## PRICEMAT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the price per \$100 face value of a security that pays interest at maturity.

## PRICEDISC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the price per \$100 face value of a discounted security.

## PRICE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the price per \$100 face value of a security that pays periodic interest.

## PPMT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the payment on the principal for an investment for a given period.

## POWER

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the result of a number raised to a power.

## POISSON

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the Poisson distribution.

## POISSON.DIST

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the Poisson distribution.

## PMT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the periodic payment for an annuity.

## PI

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the value of pi.

## PHONETIC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Text

Extracts the phonetic (furigana) characters from a text string.

## PHI

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the value of the density function for a standard normal distribution.

## PERMUTATIONA

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

## PERMUT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the number of permutations for a given number of objects.

## PERCENTRANK

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the percentage rank of a value in a data set.

## PERCENTRANK.INC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the percentage rank of a value in a data set.

## PERCENTRANK.EXC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the rank of a value in a data set as a percentage (0.1, exclusive) of the data set.

## PERCENTILE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the k-th percentile of values in a range.

## PERCENTILE.INC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the k-th percentile of values in a range.

## PERCENTILE.EXC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the k-th percentile of values in a range, where k is in the range 0.1, exclusive.

## PEARSON

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the Pearson product moment correlation coefficient.

## PDURATION

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the number of periods required by an investment to reach a specified value.

## OR

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Logical

Returns TRUE if any argument is TRUE.

## OFFSET

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Lookup and reference

Returns a reference offset from a given reference.

## ODDLYIELD

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the yield of a security with an odd last period.

## ODDLPRICE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the price per \$100 face value of a security with an odd last period.

## ODDFYIELD

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the yield of a security with an odd first period.

## ODDFPRICE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the price per \$100 face value of a security with an odd first period.

## ODD

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Rounds a number up to the nearest odd integer.

## OCT2HEX

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Engineering

Converts an octal number to hexadecimal.

## OCT2DEC

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Engineering

Converts an octal number to decimal.

## OCT2BIN

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Engineering

Converts an octal number to binary.

## NUMBERVALUE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Text

Converts text to number in a locale-independent manner.

## NPV

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

## NPER

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the number of periods for an investment.

## NOW

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Date and time

Returns the serial number of the current date and time.

## NOT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Logical

Reverses the logic of its argument.

## NORMSINV

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the inverse of the standard normal cumulative distribution.

## NORM.S.INV

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the inverse of the standard normal cumulative distribution.

## NORMSDIST

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the standard normal cumulative distribution.

## NORM.S.DIST

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the standard normal cumulative distribution.

## NORM.INV

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the inverse of the normal cumulative distribution.

## NORMINV

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the inverse of the normal cumulative distribution.

## NORMDIST

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the normal cumulative distribution.

## NORM.DIST

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the normal cumulative distribution.

## NOMINAL

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the annual nominal interest rate.

## NETWORKDAYS.INTL

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Date and time

Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.

## NETWORKDAYS

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Date and time

Returns the number of whole workdays between two dates.

## NEGBINOMDIST

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the negative binomial distribution.

## NEGBINOM.DIST

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the negative binomial distribution.

## NA

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Information

Returns the error value #N/A.

## N

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Information

Returns a value converted to a number.

## MUNIT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the unit matrix or the specified dimension.

## MULTINOMIAL

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the multinomial of a set of numbers.

## MROUND

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns a number rounded to the desired multiple.

## MONTH

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Date and time

Converts a serial number to a month.

## MODE.SNGL

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the most common value in a data set.

## MODE.MULT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.

## MODE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Compatibility

Returns the most common value in a data set.

## MOD

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the remainder from division.

## MMULT

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the matrix product of two arrays.

## MIRR

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the internal rate of return where positive and negative cash flows are financed at different rates.

## MINVERSE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the matrix inverse of an array.

## MINUTE

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Date and time

Converts a serial number to a minute.

## MINA

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the smallest value in a list of arguments, including numbers, text, and logical values.

## MINIFS

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the minimum value among cells specified by a given set of conditions or criteria.

## MIN

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the minimum value in a list of arguments.

## MID, MIDBs

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Text

Returns a specific number of characters from a text string starting at the position you specify.

## MEDIAN

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the median of the given numbers.

## MDURATION

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Financial

Returns the Macauley modified duration for a security with an assumed par value of \$100.

## MDETERM

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Math and trigonometry

Returns the matrix determinant of an array.

## MAXIFS

Опубликовано: February 13, 2021 в 11:35 am

Автор:

Категории: Statistical

Returns the maximum value among cells specified by a given set of conditions or criteria.

## MAXA

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the maximum value in a list of arguments, including numbers, text, and logical values.

## MAX

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the maximum value in a list of arguments.

## MATCH

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Looks up values in a reference or array.

## LOWER

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Text

Converts text to lowercase.

## LOOKUP

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Looks up values in a vector or array.

## LOGNORM.INV

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the inverse of the lognormal cumulative distribution.

## LOGNORMDIST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Compatibility

Returns the cumulative lognormal distribution.

## LOGNORM.DIST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the cumulative lognormal distribution.

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Compatibility

Returns the inverse of the lognormal cumulative distribution.

## LOGEST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the parameters of an exponential trend.

## LOG10

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Returns the base-10 logarithm of a number.

## LOG

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Returns the logarithm of a number to a specified base.

## LN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Returns the natural logarithm of a number.

## LINEST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the parameters of a linear trend.

## LET

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula.

## LEN, LENBs

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Text

Returns the number of characters in a text string.

## LEFT, LEFTBs

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Text

Returns the leftmost characters from a text value.

## LCM

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Returns the least common multiple.

## LARGE

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the k-th largest value in a data set.

## KURT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the kurtosis of a data set.

## JIS

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Text

Changes half-width (single-byte) characters within a string to full-width (double-byte) characters.

## ISPMT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Financial

Calculates the interest paid during a specific period of an investment.

## ISOWEEKNUM

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Date and time

Returns the number of the ISO week number of the year for a given date.

## ISO.CEILING

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.

## ISTEXT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is text.

## ISREF

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is a reference.

## ISODD

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the number is odd.

## ISNUMBER

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is a number.

## ISNONTEXT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is not text.

## ISNA

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is the #N/A error value.

## ISLOGICAL

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is a logical value.

## ISFORMULA

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if there is a reference to a cell that contains a formula.

## ISEVEN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the number is even.

## ISERROR

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is any error value.

## ISERR

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is any error value except #N/A.

## ISBLANK

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns TRUE if the value is blank.

## IRR

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Financial

Returns the internal rate of return for a series of cash flows.

## IPMT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Financial

Returns the interest payment for an investment for a given period.

## INTRATE

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Financial

Returns the interest rate for a fully invested security.

## INTERCEPT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the intercept of the linear regression line.

## INT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Rounds a number down to the nearest integer.

## INFO

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Information

Returns information about the current operating environment.

## INDIRECT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Returns a reference indicated by a text value.

## INDEX

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Uses an index to choose a value from a reference or array.

## IMTAN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the tangent of a complex number.

## IMSUM

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the sum of complex numbers.

## IMSUB

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the difference between two complex numbers.

## IMSQRT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the square root of a complex number.

## IMSINH

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the hyperbolic sine of a complex number.

## IMSIN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the sine of a complex number.

## IMSECH

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the hyperbolic secant of a complex number.

## IMSEC

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the secant of a complex number.

## IMREAL

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the real coefficient of a complex number.

## IMPRODUCT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the product of complex numbers.

## IMPOWER

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns a complex number raised to an integer power.

## IMLOG2

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the base-2 logarithm of a complex number.

## IMLOG10

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the base-10 logarithm of a complex number.

## IMLN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the natural logarithm of a complex number.

## IMEXP

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the exponential of a complex number.

## IMDIV

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the quotient of two complex numbers.

## IMCSCH

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the hyperbolic cosecant of a complex number.

## IMCSC

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the cosecant of a complex number.

## IMCOT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the cotangent of a complex number.

## IMCOSH

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the hyperbolic cosine of a complex number.

## IMCOS

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the cosine of a complex number.

## IMCONJUGATE

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the complex conjugate of a complex number.

## IMARGUMENT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the argument theta, an angle expressed in radians.

## IMAGINARY

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the imaginary coefficient of a complex number.

## IMABS

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Returns the absolute value (modulus) of a complex number.

## IFS

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Logical

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

## IFNA

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Logical

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.

## IFERROR

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Logical

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

## IF

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Logical

Specifies a logical test to perform.

## HYPGEOMDIST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Compatibility

Returns the hypergeometric distribution.

## HYPGEOM.DIST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the hypergeometric distribution.

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

## HOUR

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Date and time

Converts a serial number to an hour.

## HLOOKUP

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Looks in the top row of an array and returns the value of the indicated cell.

## HEX2OCT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Converts a hexadecimal number to octal.

## HEX2DEC

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Converts a hexadecimal number to decimal.

## HEX2BIN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Converts a hexadecimal number to binary.

## HARMEAN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the harmonic mean.

## GROWTH

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns values along an exponential trend.

## GETPIVOTDATA

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Returns data stored in a PivotTable report.

## GESTEP

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Engineering

Tests whether a number is greater than a threshold value.

## GEOMEAN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the geometric mean.

## GCD

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Returns the greatest common divisor.

## GAUSS

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns 0.5 less than the standard normal cumulative distribution.

## GAMMALN.PRECISE

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the natural logarithm of the gamma function, Γ(x).

## GAMMALN

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the natural logarithm of the gamma function, Γ(x).

## GAMMAINV

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Compatibility

Returns the inverse of the gamma cumulative distribution.

## GAMMA.INV

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the inverse of the gamma cumulative distribution.

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Compatibility

Returns the gamma distribution.

## GAMMA.DIST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the gamma distribution.

## GAMMA

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the Gamma function value.

## FVSCHEDULE

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Financial

Returns the future value of an initial principal after applying a series of compound interest rates.

## FV

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Financial

Returns the future value of an investment.

## FTEST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Compatibility

Returns the result of an F-test.

## F.TEST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the result of an F-test.

## FREQUENCY

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns a frequency distribution as a vertical array.

## FORMULATEXT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Returns the formula at the given reference as text.

## FORECAST.LINEAR

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns a future value based on existing values.

## FORECAST.ETS.STAT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns a statistical value as a result of time series forecasting.

## FORECAST.ETS.SEASONALITY

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the length of the repetitive pattern Excel detects for the specified time series.

## FORECAST.ETS.CONFINT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns a confidence interval for the forecast value at the specified target date.

## FORECAST.ETS

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.

## FORECAST

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns a value along a linear trend.

## FLOOR.PRECISE

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

## FLOOR.MATH

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Math and trigonometry

Rounds a number down, to the nearest integer or to the nearest multiple of significance.

## FLOOR

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Compatibility

Rounds a number down, toward zero.

## FIXED

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Text

Formats a number as text with a fixed number of decimals.

## FISHERINV

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the inverse of the Fisher transformation.

## FISHER

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the Fisher transformation.

## FINV

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the inverse of the F probability distribution.

## F.INV.RT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the inverse of the F probability distribution.

## F.INV

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the inverse of the F probability distribution.

## FIND, FINDBs

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Text

Finds one text value within another (case-sensitive).

## FILTERXML

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Web

Returns specific data from the XML content by using the specified XPath.

## FILTER

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Lookup and reference

Filters a range of data based on criteria you define.

## F.DIST.RT

Опубликовано: February 13, 2021 в 11:34 am

Автор:

Категории: Statistical

Returns the F probability distribution.

## FDIST

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Compatibility

Returns the F probability distribution.

## F.DIST

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the F probability distribution.

## FALSE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Logical

Returns the logical value FALSE.

## FACTDOUBLE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the double factorial of a number.

## FACT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the factorial of a number.

## EXPONDIST

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Compatibility

Returns the exponential distribution.

## EXPON.DIST

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the exponential distribution.

## EXP

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns.

## EXACT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Text

Checks to see if two text values are identical.

## EVEN

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Rounds a number up to the nearest even integer.

## EUROCONVERT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation).

## ERROR.TYPE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Information

Returns a number corresponding to an error type.

## ERFC.PRECISE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Returns the complementary ERF function integrated between x and infinity.

## ERFC

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Returns the complementary error function.

## ERF.PRECISE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Returns the error function.

## ERF

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Returns the error function.

## EOMONTH

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Date and time

Returns the serial number of the last day of the month before or after a specified number of months.

## ENCODEURL

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Web

Returns a URL-encoded string.

## EFFECT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the effective annual interest rate.

## EDATE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Date and time

Returns the serial number of the date that is the indicated number of months before or after the start date.

## DVARP

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Calculates variance based on the entire population of selected database entries.

## DVAR

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Estimates variance based on a sample from selected database entries.

## DURATION

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the annual duration of a security with periodic interest payments.

## DSUM

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Adds the numbers in the field column of records in the database that match the criteria.

## DSTDEVP

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Calculates the standard deviation based on the entire population of selected database entries.

## DSTDEV

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Estimates the standard deviation based on a sample of selected database entries.

## DPRODUCT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Multiplies the values in a particular field of records that match the criteria in a database.

## DOLLARFR

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.

## DOLLARDE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

## DOLLAR

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Text

Converts a number to text, using the \$ (dollar) currency format.

## DMIN

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Returns the minimum value from selected database entries.

## DMAX

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Returns the maximum value from selected database entries.

## DISC

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the discount rate for a security.

## DGET

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Extracts from a database a single record that matches the specified criteria.

## DEVSQ

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the sum of squares of deviations.

## DELTA

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Tests whether two values are equal.

## DEGREES

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

## DECIMAL

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Converts a text representation of a number in a given base into a decimal number.

## DEC2OCT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Converts a decimal number to octal.

## DEC2HEX

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Converts a decimal number to hexadecimal.

## DEC2BIN

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Converts a decimal number to binary.

## DDB

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.

## DCOUNTA

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Counts nonblank cells in a database.

## DCOUNT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Counts the cells that contain numbers in a database.

## DBCS

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Text

Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.

## DB

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the depreciation of an asset for a specified period by using the fixed-declining balance method.

## DAYS360

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Date and time

Calculates the number of days between two dates based on a 360-day year.

## DAYS

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Date and time

Returns the number of days between two dates.

## DAY

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Date and time

Converts a serial number to a day of the month.

## DAVERAGE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Database

Returns the average of selected database entries.

## DATEVALUE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Date and time

Converts a date in the form of text to a serial number.

## DATEDIF

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Date and time

Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.

## DATE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Date and time

Returns the serial number of a particular date.

## CUMPRINC

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the cumulative principal paid on a loan between two periods.

## CUMIPMT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the cumulative interest paid between two periods.

## CUBEVALUE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Cube

Returns an aggregated value from a cube.

## CUBESETCOUNT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Cube

Returns the number of items in a set.

## CUBESET

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Cube

Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.

## CUBERANKEDMEMBER

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Cube

Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.

## CUBEMEMBERPROPERTY

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Cube

Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.

## CUBEMEMBER

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Cube

Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.

## CUBEKPIMEMBER

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Cube

Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization’s performance.

## CSCH

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the hyperbolic cosecant of an angle.

## CSC

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the cosecant of an angle.

## CRITBINOM

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Compatibility

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.

## COVARIANCE.S

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the sample covariance, the average of the products deviations for each data point pair in two data sets.

## COVARIANCE.P

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns covariance, the average of the products of paired deviations.

## COVAR

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Compatibility

Returns covariance, the average of the products of paired deviations.

## COUPPCD

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the previous coupon date before the settlement date.

## COUPNUM

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the number of coupons payable between the settlement date and maturity date.

## COUPNCD

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the next coupon date after the settlement date.

## COUPDAYSNC

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the number of days from the settlement date to the next coupon date.

## COUPDAYS

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the number of days in the coupon period that contains the settlement date.

## COUPDAYBS

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Financial

Returns the number of days from the beginning of the coupon period to the settlement date.

## COUNTIFS

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Counts the number of cells within a range that meet multiple criteria.

## COUNTIF

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Counts the number of cells within a range that meet the given criteria.

## COUNTBLANK

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Counts the number of blank cells within a range.

## COUNTA

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Counts how many values are in the list of arguments.

## COUNT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Counts how many numbers are in the list of arguments.

## COTH

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the cotangent of an angle.

## COT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the hyperbolic cosine of a number.

## COSH

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the hyperbolic cosine of a number.

## COS

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the cosine of a number.

## CORREL

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the correlation coefficient between two data sets.

## CONVERT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Converts a number from one measurement system to another.

## CONFIDENCE.T

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the confidence interval for a population mean, using a Student’s t distribution.

## CONFIDENCE.NORM

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the confidence interval for a population mean.

## CONFIDENCE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Compatibility

Returns the confidence interval for a population mean.

## CONCATENATE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Text

Joins several text items into one text item.

## CONCAT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Text

Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments.

## COMPLEX

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Engineering

Converts real and imaginary coefficients into a complex number.

## COMBINA

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the number of combinations (with repetitions) for a given number of items.

## COMBIN

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Math and trigonometry

Returns the number of combinations for a given number of objects.

## COLUMNS

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Lookup and reference

Returns the number of columns in a reference.

## COLUMN

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Lookup and reference

Returns the column number of a reference.

## CODE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Text

Returns a numeric code for the first character in a text string.

## CLEAN

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Text

Removes all nonprintable characters from text.

## CHOOSE

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Lookup and reference

Chooses a value from a list of values.

## CHISQ.TEST

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the test for independence.

## CHISQ.INV.RT

Опубликовано: February 13, 2021 в 11:33 am

Автор:

Категории: Statistical

Returns the inverse of the one-tailed probability of the chi-squared distribution.

## CHISQ.INV

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the cumulative beta probability density function.

## CHISQ.DIST.RT

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the one-tailed probability of the chi-squared distribution.

## CHISQ.DIST

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the cumulative beta probability density function.

## CHITEST

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Compatibility

Returns the test for independence.

## CHIINV

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Compatibility

Returns the inverse of the one-tailed probability of the chi-squared distribution.

## CHIDIST

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Compatibility

Returns the one-tailed probability of the chi-squared distribution.

## CHAR

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Text

Returns the character specified by the code number.

## CELL

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Information

Returns information about the formatting, location, or contents of a cell.

## CEILING.PRECISE

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

## CEILING.MATH

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

## CEILING

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Rounds a number to the nearest integer or to the nearest multiple of significance.

## CALL

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Calls a procedure in a dynamic link library or code resource.

## BITXOR

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns a bitwise ‘Exclusive Or’ of two numbers.

## BITRSHIFT

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns a value number shifted right by shift_amount bits.

## BITOR

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns a bitwise OR of 2 numbers.

## BITLSHIFT

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns a value number shifted left by shift_amount bits.

## BITAND

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns a ‘Bitwise And’ of two numbers.

## BINOM.INV

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.

## BINOM.DIST.RANGE

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the probability of a trial result using a binomial distribution.

## BINOM.DIST

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the individual term binomial distribution probability.

## BINOMDIST

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Compatibility

Returns the individual term binomial distribution probability.

## BIN2OCT

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Converts a binary number to octal.

## BIN2HEX

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Converts a binary number to hexadecimal.

## BIN2DEC

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Converts a binary number to decimal.

## BETA.INV

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the inverse of the cumulative distribution function for a specified beta distribution.

## BETAINV

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Compatibility

Returns the inverse of the cumulative distribution function for a specified beta distribution.

## BETA.DIST

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the beta cumulative distribution function.

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Compatibility

Returns the beta cumulative distribution function.

## BESSELY

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns the Bessel function Yn(x).

## BESSELK

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns the modified Bessel function Kn(x).

## BESSELJ

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns the Bessel function Jn(x).

## BESSELI

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Engineering

Returns the modified Bessel function In(x).

## BASE

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Converts a number into a text representation with the given radix (base).

## BAHTTEXT

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Text

Converts a number to text, using the ß (baht) currency format.

## AVERAGEIFS

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

## AVERAGEIF

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

## AVERAGEA

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the average of its arguments, including numbers, text, and logical values.

## AVERAGE

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the average of its arguments.

## AVEDEV

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Statistical

Returns the average of the absolute deviations of data points from their mean.

## ATANH

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the inverse hyperbolic tangent of a number.

## ATAN2

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the arctangent from x- and y-coordinates.

## ATAN

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the arctangent of a number.

## ASINH

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the inverse hyperbolic sine of a number.

## ASIN

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the arcsine of a number.

## ASC

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Text

Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters.

## ARRAYTOTEXT

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Text

Returns an array of text values from any specified range.

## AREAS

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Lookup and reference

Returns the number of areas in a reference.

## ARABIC

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Converts a Roman number to Arabic, as a number.

## AND

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Logical

Returns TRUE if all of its arguments are TRUE.

## AMORLINC

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Financial

Returns the depreciation for each accounting period.

## AMORDEGRC

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Financial

Returns the depreciation for each accounting period by using a depreciation coefficient.

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Lookup and reference

Returns a reference as text to a single cell in a worksheet.

## AGGREGATE

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns an aggregate in a list or database.

## ACOTH

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the hyperbolic arccotangent of a number.

## ACOT

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the arccotangent of a number.

## ACOSH

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the inverse hyperbolic cosine of a number.

## ACOS

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the arccosine of a number.

## ACCRINTM

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Financial

Returns the accrued interest for a security that pays interest at maturity.

## ACCRINT

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Financial

Returns the accrued interest for a security that pays periodic interest.

## ABS

Опубликовано: February 13, 2021 в 11:32 am

Автор:

Категории: Math and trigonometry

Returns the absolute value of a number.