Справочник функций Calc
Материал из Forumooo wiki
(Различия между версиями)
Helen (Обсуждение | вклад) м |
Helen (Обсуждение | вклад) (+ аналог и описание) |
||
Строка 4: | Строка 4: | ||
!Название функции | !Название функции | ||
!Категория | !Категория | ||
+ | !Аналог функции в MS Excel | ||
+ | !Описание | ||
|- | |- | ||
| [[Calc/Functions/ADDRESS | ADDRESS]] | | [[Calc/Functions/ADDRESS | ADDRESS]] | ||
|Электронная таблица | |Электронная таблица | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ABS | ABS]] | | [[Calc/Functions/ABS | ABS]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ACCRINT | ACCRINT]] | | [[Calc/Functions/ACCRINT | ACCRINT]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ACCRINTM | ACCRINTM]] | | [[Calc/Functions/ACCRINTM | ACCRINTM]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ACOS | ACOS]] | | [[Calc/Functions/ACOS | ACOS]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ACOSH | ACOSH]] | | [[Calc/Functions/ACOSH | ACOSH]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ACOT | ACOT]] | | [[Calc/Functions/ACOT | ACOT]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ACOTH | ACOTH]] | | [[Calc/Functions/ACOTH | ACOTH]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/AMORDEGRC | AMORDEGRC]] | | [[Calc/Functions/AMORDEGRC | AMORDEGRC]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/AMORLINC | AMORLINC]] | | [[Calc/Functions/AMORLINC | AMORLINC]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/AND | AND]] | | [[Calc/Functions/AND | AND]] | ||
- | |Логические | + | |Логические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ARABIC | ARABIC]] | | [[Calc/Functions/ARABIC | ARABIC]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/AREAS | AREAS]] | | [[Calc/Functions/AREAS | AREAS]] | ||
|Электронная таблица | |Электронная таблица | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ASIN | ASIN]] | | [[Calc/Functions/ASIN | ASIN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ASINH | ASINH]] | | [[Calc/Functions/ASINH | ASINH]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ATAN | ATAN]] | | [[Calc/Functions/ATAN | ATAN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ATAN2 | ATAN2]] | | [[Calc/Functions/ATAN2 | ATAN2]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ATANH | ATANH]] | | [[Calc/Functions/ATANH | ATANH]] | ||
|Математические | |Математические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/AVEDEV | AVEDEV]] | | [[Calc/Functions/AVEDEV | AVEDEV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/AVERAGE | AVERAGE]] | | [[Calc/Functions/AVERAGE | AVERAGE]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/AVERAGEA | AVERAGEA]] | | [[Calc/Functions/AVERAGEA | AVERAGEA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/B | B]] | | [[Calc/Functions/B | B]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BAHTTEXT | BAHTTEXT]] | | [[Calc/Functions/BAHTTEXT | BAHTTEXT]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BASE | BASE]] | | [[Calc/Functions/BASE | BASE]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BESSELI | BESSELI]] | | [[Calc/Functions/BESSELI | BESSELI]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BESSELJ | BESSELJ]] | | [[Calc/Functions/BESSELJ | BESSELJ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BESSELK | BESSELK]] | | [[Calc/Functions/BESSELK | BESSELK]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BESSELY | BESSELY]] | | [[Calc/Functions/BESSELY | BESSELY]] | ||
|Дополнительные | |Дополнительные | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BETADIST | BETADIST]] | | [[Calc/Functions/BETADIST | BETADIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BETAINV | BETAINV]] | | [[Calc/Functions/BETAINV | BETAINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ BIN2DEC | BIN2DEC ]] | | [[Calc/Functions/ BIN2DEC | BIN2DEC ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ BIN2HEX | BIN2HEX ]] | | [[Calc/Functions/ BIN2HEX | BIN2HEX ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BIN2OCT | BIN2OCT]] | | [[Calc/Functions/BIN2OCT | BIN2OCT]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/BINOMDIST | BINOMDIST]] | | [[Calc/Functions/BINOMDIST | BINOMDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CEILING | CEILING]] | | [[Calc/Functions/CEILING | CEILING]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CELL | CELL]] | | [[Calc/Functions/CELL | CELL]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CHAR | CHAR]] | | [[Calc/Functions/CHAR | CHAR]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CHIDIST | CHIDIST]] | | [[Calc/Functions/CHIDIST | CHIDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CHIINV | CHIINV]] | | [[Calc/Functions/CHIINV | CHIINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CHISQDIST | CHISQDIST]] | | [[Calc/Functions/CHISQDIST | CHISQDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CHISQINV | CHISQINV]] | | [[Calc/Functions/CHISQINV | CHISQINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CHITEST | CHITEST]] | | [[Calc/Functions/CHITEST | CHITEST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CHOOSE | CHOOSE]] | | [[Calc/Functions/CHOOSE | CHOOSE]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CLEAN | CLEAN]] | | [[Calc/Functions/CLEAN | CLEAN]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CODE | CODE]] | | [[Calc/Functions/CODE | CODE]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COLUMN | COLUMN]] | | [[Calc/Functions/COLUMN | COLUMN]] | ||
|Электронная таблица | |Электронная таблица | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COLUMNS | COLUMNS]] | | [[Calc/Functions/COLUMNS | COLUMNS]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COMBIN | COMBIN]] | | [[Calc/Functions/COMBIN | COMBIN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COMBINA | COMBINA]] | | [[Calc/Functions/COMBINA | COMBINA]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COMPLEX | COMPLEX]] | | [[Calc/Functions/COMPLEX | COMPLEX]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CONCATENATE | CONCATENATE]] | | [[Calc/Functions/CONCATENATE | CONCATENATE]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CONFIDENCE | CONFIDENCE]] | | [[Calc/Functions/CONFIDENCE | CONFIDENCE]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CONVERT | CONVERT]] | | [[Calc/Functions/CONVERT | CONVERT]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CONVERT_ADD | CONVERT_ADD ]] | | [[Calc/Functions/CONVERT_ADD | CONVERT_ADD ]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CORREL | CORREL]] | | [[Calc/Functions/CORREL | CORREL]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COS | COS]] | | [[Calc/Functions/COS | COS]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COSH | COSH]] | | [[Calc/Functions/COSH | COSH]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COT | COT]] | | [[Calc/Functions/COT | COT]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COTH | COTH]] | | [[Calc/Functions/COTH | COTH]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUNT | COUNT]] | | [[Calc/Functions/COUNT | COUNT]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUNTA | COUNTA]] | | [[Calc/Functions/COUNTA | COUNTA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUNTBLANK | COUNTBLANK]] | | [[Calc/Functions/COUNTBLANK | COUNTBLANK]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUNTIF | COUNTIF]] | | [[Calc/Functions/COUNTIF | COUNTIF]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUPDAYBS | COUPDAYBS]] | | [[Calc/Functions/COUPDAYBS | COUPDAYBS]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUPDAYS | COUPDAYS]] | | [[Calc/Functions/COUPDAYS | COUPDAYS]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUPDAYSNC | COUPDAYSNC]] | | [[Calc/Functions/COUPDAYSNC | COUPDAYSNC]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUPNCD | COUPNCD]] | | [[Calc/Functions/COUPNCD | COUPNCD]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUPNUM | COUPNUM]] | | [[Calc/Functions/COUPNUM | COUPNUM]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COUPPCD | COUPPCD]] | | [[Calc/Functions/COUPPCD | COUPPCD]] | ||
|Финансовые | |Финансовые | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/COVAR | COVAR]] | | [[Calc/Functions/COVAR | COVAR]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CRITBINOM | CRITBINOM]] | | [[Calc/Functions/CRITBINOM | CRITBINOM]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CUMIPMT | CUMIPMT]] | | [[Calc/Functions/CUMIPMT | CUMIPMT]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CUMIPMT_ADD | CUMIPMT_ADD ]] | | [[Calc/Functions/CUMIPMT_ADD | CUMIPMT_ADD ]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CUMPRINC | CUMPRINC]] | | [[Calc/Functions/CUMPRINC | CUMPRINC]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CUMPRINC_ADD | CUMPRINC_ADD ]] | | [[Calc/Functions/CUMPRINC_ADD | CUMPRINC_ADD ]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/CURRENT | CURRENT]] | | [[Calc/Functions/CURRENT | CURRENT]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DATE | DATE]] | | [[Calc/Functions/DATE | DATE]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DATEVALUE | DATEVALUE]] | | [[Calc/Functions/DATEVALUE | DATEVALUE]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DAVERAGE | DAVERAGE]] | | [[Calc/Functions/DAVERAGE | DAVERAGE]] | ||
|База данных | |База данных | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DAY | DAY]] | | [[Calc/Functions/DAY | DAY]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DAYS | DAYS]] | | [[Calc/Functions/DAYS | DAYS]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DAYS360 | DAYS360 ]] | | [[Calc/Functions/DAYS360 | DAYS360 ]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DAYSINMONTH | DAYSINMONTH]] | | [[Calc/Functions/DAYSINMONTH | DAYSINMONTH]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DAYSINYEAR | DAYSINYEAR]] | | [[Calc/Functions/DAYSINYEAR | DAYSINYEAR]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DB | DB]] | | [[Calc/Functions/DB | DB]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DCOUNT | DCOUNT]] | | [[Calc/Functions/DCOUNT | DCOUNT]] | ||
|База данных | |База данных | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DCOUNTA | DCOUNTA]] | | [[Calc/Functions/DCOUNTA | DCOUNTA]] | ||
|База данных | |База данных | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DDB | DDB]] | | [[Calc/Functions/DDB | DDB]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DDE | DDE]] | | [[Calc/Functions/DDE | DDE]] | ||
Строка 273: | Строка 451: | ||
|- | |- | ||
| [[Calc/Functions/DEC2BIN | DEC2BIN ]] | | [[Calc/Functions/DEC2BIN | DEC2BIN ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DEC2HEX | DEC2HEX ]] | | [[Calc/Functions/DEC2HEX | DEC2HEX ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DEC2OCT | DEC2OCT ]] | | [[Calc/Functions/DEC2OCT | DEC2OCT ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DECIMAL | DECIMAL]] | | [[Calc/Functions/DECIMAL | DECIMAL]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DEGREES | DEGREES]] | | [[Calc/Functions/DEGREES | DEGREES]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DELTA | DELTA]] | | [[Calc/Functions/DELTA | DELTA]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DEVSQ | DEVSQ]] | | [[Calc/Functions/DEVSQ | DEVSQ]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DGET | DGET]] | | [[Calc/Functions/DGET | DGET]] | ||
|База данных | |База данных | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DISC | DISC]] | | [[Calc/Functions/DISC | DISC]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DMAX | DMAX]] | | [[Calc/Functions/DMAX | DMAX]] | ||
|База данных | |База данных | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DMIN | DMIN]] | | [[Calc/Functions/DMIN | DMIN]] | ||
|База данных | |База данных | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DOLLAR | DOLLAR]] | | [[Calc/Functions/DOLLAR | DOLLAR]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DOLLARDE | DOLLARDE]] | | [[Calc/Functions/DOLLARDE | DOLLARDE]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DOLLARFR | DOLLARFR]] | | [[Calc/Functions/DOLLARFR | DOLLARFR]] | ||
|Финансовые | |Финансовые | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DPRODUCT | DPRODUCT]] | | [[Calc/Functions/DPRODUCT | DPRODUCT]] | ||
|База данных | |База данных | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DSTDEV | DSTDEV]] | | [[Calc/Functions/DSTDEV | DSTDEV]] | ||
|База данных | |База данных | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DSTDEVP | DSTDEVP]] | | [[Calc/Functions/DSTDEVP | DSTDEVP]] | ||
- | |База данных | + | |База данных |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DSUM | DSUM]] | | [[Calc/Functions/DSUM | DSUM]] | ||
- | |База данных | + | |База данных |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DURATION | DURATION]] | | [[Calc/Functions/DURATION | DURATION]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DURATION_ADD | DURATION_ADD ]] | | [[Calc/Functions/DURATION_ADD | DURATION_ADD ]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DVAR | DVAR]] | | [[Calc/Functions/DVAR | DVAR]] | ||
- | |База данных | + | |База данных |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/DVARP | DVARP]] | | [[Calc/Functions/DVARP | DVARP]] | ||
- | |База данных | + | |База данных |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EASTERSUNDAY | EASTERSUNDAY]] | | [[Calc/Functions/EASTERSUNDAY | EASTERSUNDAY]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EDATE | EDATE]] | | [[Calc/Functions/EDATE | EDATE]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EFFECT_ADD | EFFECT_ADD ]] | | [[Calc/Functions/EFFECT_ADD | EFFECT_ADD ]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EFFECTIVE | EFFECTIVE]] | | [[Calc/Functions/EFFECTIVE | EFFECTIVE]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EOMONTH | EOMONTH]] | | [[Calc/Functions/EOMONTH | EOMONTH]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ERF | ERF]] | | [[Calc/Functions/ERF | ERF]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ERFC | ERFC]] | | [[Calc/Functions/ERFC | ERFC]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ERRORTYPE | ERRORTYPE]] | | [[Calc/Functions/ERRORTYPE | ERRORTYPE]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EVEN | EVEN]] | | [[Calc/Functions/EVEN | EVEN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EXACT | EXACT]] | | [[Calc/Functions/EXACT | EXACT]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EXP | EXP]] | | [[Calc/Functions/EXP | EXP]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/EXPONDIST | EXPONDIST]] | | [[Calc/Functions/EXPONDIST | EXPONDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FACT | FACT]] | | [[Calc/Functions/FACT | FACT]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FACTDOUBLE | FACTDOUBLE]] | | [[Calc/Functions/FACTDOUBLE | FACTDOUBLE]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FALSE | FALSE]] | | [[Calc/Functions/FALSE | FALSE]] | ||
- | |Логические | + | |Логические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FDIST | FDIST]] | | [[Calc/Functions/FDIST | FDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FIND | FIND]] | | [[Calc/Functions/FIND | FIND]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FINV | FINV]] | | [[Calc/Functions/FINV | FINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FISHER | FISHER]] | | [[Calc/Functions/FISHER | FISHER]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FISHERINV | FISHERINV]] | | [[Calc/Functions/FISHERINV | FISHERINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FIXED | FIXED]] | | [[Calc/Functions/FIXED | FIXED]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FLOOR | FLOOR]] | | [[Calc/Functions/FLOOR | FLOOR]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FORECAST | FORECAST]] | | [[Calc/Functions/FORECAST | FORECAST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FORMULA | FORMULA]] | | [[Calc/Functions/FORMULA | FORMULA]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FREQUENCY | FREQUENCY]] | | [[Calc/Functions/FREQUENCY | FREQUENCY]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FTEST | FTEST]] | | [[Calc/Functions/FTEST | FTEST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FV | FV]] | | [[Calc/Functions/FV | FV]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/FVSCHEDULE | FVSCHEDULE]] | | [[Calc/Functions/FVSCHEDULE | FVSCHEDULE]] | ||
|Финансовые | |Финансовые | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GAMMA | GAMMA]] | | [[Calc/Functions/GAMMA | GAMMA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GAMMADIST | GAMMADIST]] | | [[Calc/Functions/GAMMADIST | GAMMADIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GAMMAINV | GAMMAINV]] | | [[Calc/Functions/GAMMAINV | GAMMAINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GAMMALN | GAMMALN]] | | [[Calc/Functions/GAMMALN | GAMMALN]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GAUSS | GAUSS]] | | [[Calc/Functions/GAUSS | GAUSS]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GCD | GCD]] | | [[Calc/Functions/GCD | GCD]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GCD_ADD | GCD_ADD ]] | | [[Calc/Functions/GCD_ADD | GCD_ADD ]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GEOMEAN | GEOMEAN]] | | [[Calc/Functions/GEOMEAN | GEOMEAN]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GESTEP | GESTEP]] | | [[Calc/Functions/GESTEP | GESTEP]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/GROWTH | GROWTH]] | | [[Calc/Functions/GROWTH | GROWTH]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/HARMEAN | HARMEAN]] | | [[Calc/Functions/HARMEAN | HARMEAN]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/HEX2BIN | HEX2BIN ]] | | [[Calc/Functions/HEX2BIN | HEX2BIN ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/HEX2DEC | HEX2DEC ]] | | [[Calc/Functions/HEX2DEC | HEX2DEC ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/HEX2OCT | HEX2OCT ]] | | [[Calc/Functions/HEX2OCT | HEX2OCT ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/HLOOKUP | HLOOKUP]] | | [[Calc/Functions/HLOOKUP | HLOOKUP]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/HOUR | HOUR]] | | [[Calc/Functions/HOUR | HOUR]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/HYPERLINK | HYPERLINK]] | | [[Calc/Functions/HYPERLINK | HYPERLINK]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/HYPGEOMDIST | HYPGEOMDIST]] | | [[Calc/Functions/HYPGEOMDIST | HYPGEOMDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IF | IF]] | | [[Calc/Functions/IF | IF]] | ||
- | |Логические | + | |Логические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMABS | IMABS]] | | [[Calc/Functions/IMABS | IMABS]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMAGINARY | IMAGINARY]] | | [[Calc/Functions/IMAGINARY | IMAGINARY]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMARGUMENT | IMARGUMENT]] | | [[Calc/Functions/IMARGUMENT | IMARGUMENT]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMCONJUGATE | IMCONJUGATE]] | | [[Calc/Functions/IMCONJUGATE | IMCONJUGATE]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMCOS | IMCOS]] | | [[Calc/Functions/IMCOS | IMCOS]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMDIV | IMDIV]] | | [[Calc/Functions/IMDIV | IMDIV]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMEXP | IMEXP]] | | [[Calc/Functions/IMEXP | IMEXP]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMLN | IMLN]] | | [[Calc/Functions/IMLN | IMLN]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMLOG10 | IMLOG10 ]] | | [[Calc/Functions/IMLOG10 | IMLOG10 ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMLOG2 | IMLOG2 ]] | | [[Calc/Functions/IMLOG2 | IMLOG2 ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMPOWER | IMPOWER]] | | [[Calc/Functions/IMPOWER | IMPOWER]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMPRODUCT | IMPRODUCT]] | | [[Calc/Functions/IMPRODUCT | IMPRODUCT]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMREAL | IMREAL]] | | [[Calc/Functions/IMREAL | IMREAL]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMSIN | IMSIN]] | | [[Calc/Functions/IMSIN | IMSIN]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMSQRT | IMSQRT]] | | [[Calc/Functions/IMSQRT | IMSQRT]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMSUB | IMSUB]] | | [[Calc/Functions/IMSUB | IMSUB]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IMSUM | IMSUM]] | | [[Calc/Functions/IMSUM | IMSUM]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/INDEX | INDEX]] | | [[Calc/Functions/INDEX | INDEX]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/INDIRECT | INDIRECT]] | | [[Calc/Functions/INDIRECT | INDIRECT]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/INFO | INFO]] | | [[Calc/Functions/INFO | INFO]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/INT | INT]] | | [[Calc/Functions/INT | INT]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/INTERCEPT | INTERCEPT]] | | [[Calc/Functions/INTERCEPT | INTERCEPT]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/INTRATE | INTRATE]] | | [[Calc/Functions/INTRATE | INTRATE]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IPMT | IPMT]] | | [[Calc/Functions/IPMT | IPMT]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/IRR | IRR]] | | [[Calc/Functions/IRR | IRR]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISBLANK | ISBLANK]] | | [[Calc/Functions/ISBLANK | ISBLANK]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISERR | ISERR]] | | [[Calc/Functions/ISERR | ISERR]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISERROR | ISERROR]] | | [[Calc/Functions/ISERROR | ISERROR]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISEVEN | ISEVEN]] | | [[Calc/Functions/ISEVEN | ISEVEN]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISEVEN | ISEVEN]] | | [[Calc/Functions/ISEVEN | ISEVEN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISEVEN_ADD | ISEVEN_ADD ]] | | [[Calc/Functions/ISEVEN_ADD | ISEVEN_ADD ]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISFORMULA | ISFORMULA]] | | [[Calc/Functions/ISFORMULA | ISFORMULA]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISLEAPYEAR | ISLEAPYEAR]] | | [[Calc/Functions/ISLEAPYEAR | ISLEAPYEAR]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISLOGICAL | ISLOGICAL]] | | [[Calc/Functions/ISLOGICAL | ISLOGICAL]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISNA | ISNA]] | | [[Calc/Functions/ISNA | ISNA]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISNONTEXT | ISNONTEXT]] | | [[Calc/Functions/ISNONTEXT | ISNONTEXT]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISNUMBER | ISNUMBER]] | | [[Calc/Functions/ISNUMBER | ISNUMBER]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISODD | ISODD]] | | [[Calc/Functions/ISODD | ISODD]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISODD | ISODD]] | | [[Calc/Functions/ISODD | ISODD]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISODD_ADD | ISODD_ADD ]] | | [[Calc/Functions/ISODD_ADD | ISODD_ADD ]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISPMT | ISPMT]] | | [[Calc/Functions/ISPMT | ISPMT]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISREF | ISREF]] | | [[Calc/Functions/ISREF | ISREF]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ISTEXT | ISTEXT]] | | [[Calc/Functions/ISTEXT | ISTEXT]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/KURT | KURT]] | | [[Calc/Functions/KURT | KURT]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LARGE | LARGE]] | | [[Calc/Functions/LARGE | LARGE]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LCM | LCM]] | | [[Calc/Functions/LCM | LCM]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LCM_ADD | LCM_ADD ]] | | [[Calc/Functions/LCM_ADD | LCM_ADD ]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LEFT | LEFT]] | | [[Calc/Functions/LEFT | LEFT]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LEN | LEN]] | | [[Calc/Functions/LEN | LEN]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LINEST | LINEST]] | | [[Calc/Functions/LINEST | LINEST]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LN | LN]] | | [[Calc/Functions/LN | LN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LOG | LOG]] | | [[Calc/Functions/LOG | LOG]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LOG10 | LOG10]] | | [[Calc/Functions/LOG10 | LOG10]] | ||
|Математические | |Математические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LOGEST | LOGEST]] | | [[Calc/Functions/LOGEST | LOGEST]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LOGINV | LOGINV]] | | [[Calc/Functions/LOGINV | LOGINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LOGNORMDIST | LOGNORMDIST]] | | [[Calc/Functions/LOGNORMDIST | LOGNORMDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LOOKUP | LOOKUP]] | | [[Calc/Functions/LOOKUP | LOOKUP]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/LOWER | LOWER]] | | [[Calc/Functions/LOWER | LOWER]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MATCH | MATCH]] | | [[Calc/Functions/MATCH | MATCH]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MAX | MAX]] | | [[Calc/Functions/MAX | MAX]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MAXA | MAXA]] | | [[Calc/Functions/MAXA | MAXA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MDETERM | MDETERM]] | | [[Calc/Functions/MDETERM | MDETERM]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MDURATION | MDURATION]] | | [[Calc/Functions/MDURATION | MDURATION]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MEDIAN | MEDIAN]] | | [[Calc/Functions/MEDIAN | MEDIAN]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MID | MID]] | | [[Calc/Functions/MID | MID]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MIN | MIN]] | | [[Calc/Functions/MIN | MIN]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MINA | MINA]] | | [[Calc/Functions/MINA | MINA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MINUTE | MINUTE]] | | [[Calc/Functions/MINUTE | MINUTE]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MINVERSE | MINVERSE]] | | [[Calc/Functions/MINVERSE | MINVERSE]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MIRR | MIRR]] | | [[Calc/Functions/MIRR | MIRR]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MMULT | MMULT]] | | [[Calc/Functions/MMULT | MMULT]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MOD | MOD]] | | [[Calc/Functions/MOD | MOD]] | ||
|Математические | |Математические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MODE | MODE]] | | [[Calc/Functions/MODE | MODE]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MONTH | MONTH]] | | [[Calc/Functions/MONTH | MONTH]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MONTHS | MONTHS]] | | [[Calc/Functions/MONTHS | MONTHS]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MROUND | MROUND]] | | [[Calc/Functions/MROUND | MROUND]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MULTINOMIAL | MULTINOMIAL]] | | [[Calc/Functions/MULTINOMIAL | MULTINOMIAL]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/MUNIT | MUNIT]] | | [[Calc/Functions/MUNIT | MUNIT]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/N | N]] | | [[Calc/Functions/N | N]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NA | NA]] | | [[Calc/Functions/NA | NA]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NEGBINOMDIST | NEGBINOMDIST]] | | [[Calc/Functions/NEGBINOMDIST | NEGBINOMDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NETWORKDAYS | NETWORKDAYS]] | | [[Calc/Functions/NETWORKDAYS | NETWORKDAYS]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NOMINAL | NOMINAL]] | | [[Calc/Functions/NOMINAL | NOMINAL]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NOMINAL_ADD | NOMINAL_ADD ]] | | [[Calc/Functions/NOMINAL_ADD | NOMINAL_ADD ]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NORMDIST | NORMDIST]] | | [[Calc/Functions/NORMDIST | NORMDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NORMINV | NORMINV]] | | [[Calc/Functions/NORMINV | NORMINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NORMSDIST | NORMSDIST]] | | [[Calc/Functions/NORMSDIST | NORMSDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NORMSINV | NORMSINV]] | | [[Calc/Functions/NORMSINV | NORMSINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NOT | NOT]] | | [[Calc/Functions/NOT | NOT]] | ||
- | |Логические | + | |Логические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NOW | NOW]] | | [[Calc/Functions/NOW | NOW]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NPER | NPER]] | | [[Calc/Functions/NPER | NPER]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/NPV | NPV]] | | [[Calc/Functions/NPV | NPV]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/OCT2BIN | OCT2BIN ]] | | [[Calc/Functions/OCT2BIN | OCT2BIN ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/OCT2DEC | OCT2DEC ]] | | [[Calc/Functions/OCT2DEC | OCT2DEC ]] | ||
- | |Дополнительные | + | |Дополнительные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/OCT2HEX | OCT2HEX ]] | | [[Calc/Functions/OCT2HEX | OCT2HEX ]] | ||
|Дополнительные | |Дополнительные | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ODD | ODD]] | | [[Calc/Functions/ODD | ODD]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ODDFPRICE | ODDFPRICE]] | | [[Calc/Functions/ODDFPRICE | ODDFPRICE]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ODDFYIELD | ODDFYIELD]] | | [[Calc/Functions/ODDFYIELD | ODDFYIELD]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ODDLPRICE | ODDLPRICE]] | | [[Calc/Functions/ODDLPRICE | ODDLPRICE]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ODDLYIELD | ODDLYIELD]] | | [[Calc/Functions/ODDLYIELD | ODDLYIELD]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/OFFSET | OFFSET]] | | [[Calc/Functions/OFFSET | OFFSET]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/OR | OR]] | | [[Calc/Functions/OR | OR]] | ||
- | |Логические | + | |Логические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PEARSON | PEARSON]] | | [[Calc/Functions/PEARSON | PEARSON]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PERCENTILE | PERCENTILE]] | | [[Calc/Functions/PERCENTILE | PERCENTILE]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PERCENTRANK | PERCENTRANK]] | | [[Calc/Functions/PERCENTRANK | PERCENTRANK]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PERMUT | PERMUT]] | | [[Calc/Functions/PERMUT | PERMUT]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PERMUTATIONA | PERMUTATIONA]] | | [[Calc/Functions/PERMUTATIONA | PERMUTATIONA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PHI | PHI]] | | [[Calc/Functions/PHI | PHI]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PI | PI]] | | [[Calc/Functions/PI | PI]] | ||
|Математические | |Математические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PMT | PMT]] | | [[Calc/Functions/PMT | PMT]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/POISSON | POISSON]] | | [[Calc/Functions/POISSON | POISSON]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/POWER | POWER]] | | [[Calc/Functions/POWER | POWER]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PPMT | PPMT]] | | [[Calc/Functions/PPMT | PPMT]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PRICE | PRICE]] | | [[Calc/Functions/PRICE | PRICE]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PRICEDISC | PRICEDISC]] | | [[Calc/Functions/PRICEDISC | PRICEDISC]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PRICEMAT | PRICEMAT]] | | [[Calc/Functions/PRICEMAT | PRICEMAT]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PROB | PROB]] | | [[Calc/Functions/PROB | PROB]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PRODUCT | PRODUCT]] | | [[Calc/Functions/PRODUCT | PRODUCT]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PROPER | PROPER]] | | [[Calc/Functions/PROPER | PROPER]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/PV | PV]] | | [[Calc/Functions/PV | PV]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/QUARTILE | QUARTILE]] | | [[Calc/Functions/QUARTILE | QUARTILE]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/QUOTIENT | QUOTIENT]] | | [[Calc/Functions/QUOTIENT | QUOTIENT]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RADIANS | RADIANS]] | | [[Calc/Functions/RADIANS | RADIANS]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RAND | RAND]] | | [[Calc/Functions/RAND | RAND]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RANDBETWEEN | RANDBETWEEN]] | | [[Calc/Functions/RANDBETWEEN | RANDBETWEEN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RANK | RANK]] | | [[Calc/Functions/RANK | RANK]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RATE | RATE]] | | [[Calc/Functions/RATE | RATE]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RECEIVED | RECEIVED]] | | [[Calc/Functions/RECEIVED | RECEIVED]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/REPLACE | REPLACE]] | | [[Calc/Functions/REPLACE | REPLACE]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/REPT | REPT]] | | [[Calc/Functions/REPT | REPT]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RIGHT | RIGHT]] | | [[Calc/Functions/RIGHT | RIGHT]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ROMAN | ROMAN]] | | [[Calc/Functions/ROMAN | ROMAN]] | ||
|Текстовые | |Текстовые | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ROUND | ROUND]] | | [[Calc/Functions/ROUND | ROUND]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ROUNDDOWN | ROUNDDOWN]] | | [[Calc/Functions/ROUNDDOWN | ROUNDDOWN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ROUNDUP | ROUNDUP]] | | [[Calc/Functions/ROUNDUP | ROUNDUP]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ROW | ROW]] | | [[Calc/Functions/ROW | ROW]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ROWS | ROWS]] | | [[Calc/Functions/ROWS | ROWS]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RRI | RRI]] | | [[Calc/Functions/RRI | RRI]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/RSQ | RSQ]] | | [[Calc/Functions/RSQ | RSQ]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SEARCH | SEARCH]] | | [[Calc/Functions/SEARCH | SEARCH]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SECOND | SECOND]] | | [[Calc/Functions/SECOND | SECOND]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SERIESSUM | SERIESSUM]] | | [[Calc/Functions/SERIESSUM | SERIESSUM]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SHEET | SHEET]] | | [[Calc/Functions/SHEET | SHEET]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SHEETS | SHEETS]] | | [[Calc/Functions/SHEETS | SHEETS]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SIGN | SIGN]] | | [[Calc/Functions/SIGN | SIGN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SIN | SIN]] | | [[Calc/Functions/SIN | SIN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SINH | SINH]] | | [[Calc/Functions/SINH | SINH]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SKEW | SKEW]] | | [[Calc/Functions/SKEW | SKEW]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SLN | SLN]] | | [[Calc/Functions/SLN | SLN]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SLOPE | SLOPE]] | | [[Calc/Functions/SLOPE | SLOPE]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SMALL | SMALL]] | | [[Calc/Functions/SMALL | SMALL]] | ||
|Статистические | |Статистические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SQRT | SQRT]] | | [[Calc/Functions/SQRT | SQRT]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SQRTPI | SQRTPI]] | | [[Calc/Functions/SQRTPI | SQRTPI]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/STANDARDIZE | STANDARDIZE]] | | [[Calc/Functions/STANDARDIZE | STANDARDIZE]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/STDEV | STDEV]] | | [[Calc/Functions/STDEV | STDEV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/STDEVA | STDEVA]] | | [[Calc/Functions/STDEVA | STDEVA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/STDEVP | STDEVP]] | | [[Calc/Functions/STDEVP | STDEVP]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/STDEVPA | STDEVPA]] | | [[Calc/Functions/STDEVPA | STDEVPA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/STEYX | STEYX]] | | [[Calc/Functions/STEYX | STEYX]] | ||
|Статистические | |Статистические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/STYLE | STYLE]] | | [[Calc/Functions/STYLE | STYLE]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUBSTITUTE | SUBSTITUTE]] | | [[Calc/Functions/SUBSTITUTE | SUBSTITUTE]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUBTOTAL | SUBTOTAL]] | | [[Calc/Functions/SUBTOTAL | SUBTOTAL]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUM | SUM]] | | [[Calc/Functions/SUM | SUM]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUMIF | SUMIF]] | | [[Calc/Functions/SUMIF | SUMIF]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUMPRODUCT | SUMPRODUCT]] | | [[Calc/Functions/SUMPRODUCT | SUMPRODUCT]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUMSQ | SUMSQ]] | | [[Calc/Functions/SUMSQ | SUMSQ]] | ||
|Математические | |Математические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUMX2MY2 | SUMX2MY2 ]] | | [[Calc/Functions/SUMX2MY2 | SUMX2MY2 ]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUMX2PY2 | SUMX2PY2 ]] | | [[Calc/Functions/SUMX2PY2 | SUMX2PY2 ]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SUMXMY2 | SUMXMY2 ]] | | [[Calc/Functions/SUMXMY2 | SUMXMY2 ]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/SYD | SYD]] | | [[Calc/Functions/SYD | SYD]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/T | T]] | | [[Calc/Functions/T | T]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TAN | TAN]] | | [[Calc/Functions/TAN | TAN]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TANH | TANH]] | | [[Calc/Functions/TANH | TANH]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TBILLEQ | TBILLEQ]] | | [[Calc/Functions/TBILLEQ | TBILLEQ]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TBILLPRICE | TBILLPRICE]] | | [[Calc/Functions/TBILLPRICE | TBILLPRICE]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TBILLYIELD | TBILLYIELD]] | | [[Calc/Functions/TBILLYIELD | TBILLYIELD]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TDIST | TDIST]] | | [[Calc/Functions/TDIST | TDIST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TEXT | TEXT]] | | [[Calc/Functions/TEXT | TEXT]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TIME | TIME]] | | [[Calc/Functions/TIME | TIME]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TIMEVALUE | TIMEVALUE]] | | [[Calc/Functions/TIMEVALUE | TIMEVALUE]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TINV | TINV]] | | [[Calc/Functions/TINV | TINV]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TODAY | TODAY]] | | [[Calc/Functions/TODAY | TODAY]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TRANSPOSE | TRANSPOSE]] | | [[Calc/Functions/TRANSPOSE | TRANSPOSE]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TREND | TREND]] | | [[Calc/Functions/TREND | TREND]] | ||
- | |Массив | + | |Массив |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TRIM | TRIM]] | | [[Calc/Functions/TRIM | TRIM]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TRIMMEAN | TRIMMEAN]] | | [[Calc/Functions/TRIMMEAN | TRIMMEAN]] | ||
|Статистические | |Статистические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TRUE | TRUE]] | | [[Calc/Functions/TRUE | TRUE]] | ||
- | |Логические | + | |Логические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TRUNC | TRUNC]] | | [[Calc/Functions/TRUNC | TRUNC]] | ||
- | |Математические | + | |Математические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TTEST | TTEST]] | | [[Calc/Functions/TTEST | TTEST]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/TYPE | TYPE]] | | [[Calc/Functions/TYPE | TYPE]] | ||
- | |Информационные | + | |Информационные |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/UPPER | UPPER]] | | [[Calc/Functions/UPPER | UPPER]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/VALUE | VALUE]] | | [[Calc/Functions/VALUE | VALUE]] | ||
- | |Текстовые | + | |Текстовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/VAR | VAR]] | | [[Calc/Functions/VAR | VAR]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/VARA | VARA]] | | [[Calc/Functions/VARA | VARA]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/VARP | VARP]] | | [[Calc/Functions/VARP | VARP]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/VARPA | VARPA]] | | [[Calc/Functions/VARPA | VARPA]] | ||
|Статистические | |Статистические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/VDB | VDB]] | | [[Calc/Functions/VDB | VDB]] | ||
|Финансовые | |Финансовые | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/VLOOKUP | VLOOKUP]] | | [[Calc/Functions/VLOOKUP | VLOOKUP]] | ||
- | |Электронная таблица | + | |Электронная таблица |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/WEEKDAY | WEEKDAY]] | | [[Calc/Functions/WEEKDAY | WEEKDAY]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/WEEKNUM | WEEKNUM]] | | [[Calc/Functions/WEEKNUM | WEEKNUM]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/WEEKNUM_ADD | WEEKNUM_ADD]] | | [[Calc/Functions/WEEKNUM_ADD | WEEKNUM_ADD]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/WEEKS | WEEKS]] | | [[Calc/Functions/WEEKS | WEEKS]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/WEEKSINYEAR | WEEKSINYEAR]] | | [[Calc/Functions/WEEKSINYEAR | WEEKSINYEAR]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/WEIBULL | WEIBULL]] | | [[Calc/Functions/WEIBULL | WEIBULL]] | ||
- | |Статистические | + | |Статистические |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/WORKDAY | WORKDAY]] | | [[Calc/Functions/WORKDAY | WORKDAY]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/XIRR | XIRR]] | | [[Calc/Functions/XIRR | XIRR]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/XNPV | XNPV]] | | [[Calc/Functions/XNPV | XNPV]] | ||
|Финансовые | |Финансовые | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/YEAR | YEAR]] | | [[Calc/Functions/YEAR | YEAR]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/YEARFRAC | YEARFRAC]] | | [[Calc/Functions/YEARFRAC | YEARFRAC]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/YEARS | YEARS]] | | [[Calc/Functions/YEARS | YEARS]] | ||
- | |Дата/время | + | |Дата/время |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/YIELD | YIELD]] | | [[Calc/Functions/YIELD | YIELD]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/YIELDDISC | YIELDDISC]] | | [[Calc/Functions/YIELDDISC | YIELDDISC]] | ||
- | |Финансовые | + | |Финансовые |
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/YIELDMAT | YIELDMAT]] | | [[Calc/Functions/YIELDMAT | YIELDMAT]] | ||
|Финансовые | |Финансовые | ||
+ | | | ||
+ | | | ||
|- | |- | ||
| [[Calc/Functions/ZTEST | ZTEST]] | | [[Calc/Functions/ZTEST | ZTEST]] | ||
|Статистические | |Статистические | ||
+ | | | ||
+ | | | ||
|- | |- | ||
- | |||
|} | |} |
Версия 12:53, 5 апреля 2011
Название функции | Категория | Аналог функции в MS Excel | Описание |
---|---|---|---|
ADDRESS | Электронная таблица | ||
ABS | Математические | ||
ACCRINT | Финансовые | ||
ACCRINTM | Финансовые | ||
ACOS | Математические | ||
ACOSH | Математические | ||
ACOT | Математические | ||
ACOTH | Математические | ||
AMORDEGRC | Финансовые | ||
AMORLINC | Финансовые | ||
AND | Логические | ||
ARABIC | Текстовые | ||
AREAS | Электронная таблица | ||
ASIN | Математические | ||
ASINH | Математические | ||
ATAN | Математические | ||
ATAN2 | Математические | ||
ATANH | Математические | ||
AVEDEV | Статистические | ||
AVERAGE | Статистические | ||
AVERAGEA | Статистические | ||
B | Статистические | ||
BAHTTEXT | Текстовые | ||
BASE | Текстовые | ||
BESSELI | Дополнительные | ||
BESSELJ | Дополнительные | ||
BESSELK | Дополнительные | ||
BESSELY | Дополнительные | ||
BETADIST | Статистические | ||
BETAINV | Статистические | ||
BIN2DEC | Дополнительные | ||
BIN2HEX | Дополнительные | ||
BIN2OCT | Дополнительные | ||
BINOMDIST | Статистические | ||
CEILING | Математические | ||
CELL | Информационные | ||
CHAR | Текстовые | ||
CHIDIST | Статистические | ||
CHIINV | Статистические | ||
CHISQDIST | Статистические | ||
CHISQINV | Статистические | ||
CHITEST | Статистические | ||
CHOOSE | Электронная таблица | ||
CLEAN | Текстовые | ||
CODE | Текстовые | ||
COLUMN | Электронная таблица | ||
COLUMNS | Электронная таблица | ||
COMBIN | Математические | ||
COMBINA | Математические | ||
COMPLEX | Дополнительные | ||
CONCATENATE | Текстовые | ||
CONFIDENCE | Статистические | ||
CONVERT | Математические | ||
CONVERT_ADD | Математические | ||
CORREL | Статистические | ||
COS | Математические | ||
COSH | Математические | ||
COT | Математические | ||
COTH | Математические | ||
COUNT | Статистические | ||
COUNTA | Статистические | ||
COUNTBLANK | Математические | ||
COUNTIF | Математические | ||
COUPDAYBS | Финансовые | ||
COUPDAYS | Финансовые | ||
COUPDAYSNC | Финансовые | ||
COUPNCD | Финансовые | ||
COUPNUM | Финансовые | ||
COUPPCD | Финансовые | ||
COVAR | Статистические | ||
CRITBINOM | Статистические | ||
CUMIPMT | Финансовые | ||
CUMIPMT_ADD | Финансовые | ||
CUMPRINC | Финансовые | ||
CUMPRINC_ADD | Финансовые | ||
CURRENT | Информационные | ||
DATE | Дата/время | ||
DATEVALUE | Дата/время | ||
DAVERAGE | База данных | ||
DAY | Дата/время | ||
DAYS | Дата/время | ||
DAYS360 | Дата/время | ||
DAYSINMONTH | Дата/время | ||
DAYSINYEAR | Дата/время | ||
DB | Финансовые | ||
DCOUNT | База данных | ||
DCOUNTA | База данных | ||
DDB | Финансовые | ||
DDE | Электронная таблица | ||
DEC2BIN | Дополнительные | ||
DEC2HEX | Дополнительные | ||
DEC2OCT | Дополнительные | ||
DECIMAL | Текстовые | ||
DEGREES | Математические | ||
DELTA | Математические | ||
DEVSQ | Статистические | ||
DGET | База данных | ||
DISC | Финансовые | ||
DMAX | База данных | ||
DMIN | База данных | ||
DOLLAR | Текстовые | ||
DOLLARDE | Финансовые | ||
DOLLARFR | Финансовые | ||
DPRODUCT | База данных | ||
DSTDEV | База данных | ||
DSTDEVP | База данных | ||
DSUM | База данных | ||
DURATION | Финансовые | ||
DURATION_ADD | Финансовые | ||
DVAR | База данных | ||
DVARP | База данных | ||
EASTERSUNDAY | Дата/время | ||
EDATE | Дата/время | ||
EFFECT_ADD | Финансовые | ||
EFFECTIVE | Финансовые | ||
EOMONTH | Дата/время | ||
ERF | Математические | ||
ERFC | Математические | ||
ERRORTYPE | Электронная таблица | ||
EVEN | Математические | ||
EXACT | Текстовые | ||
EXP | Математические | ||
EXPONDIST | Статистические | ||
FACT | Математические | ||
FACTDOUBLE | Математические | ||
FALSE | Логические | ||
FDIST | Статистические | ||
FIND | Текстовые | ||
FINV | Статистические | ||
FISHER | Статистические | ||
FISHERINV | Статистические | ||
FIXED | Текстовые | ||
FLOOR | Математические | ||
FORECAST | Статистические | ||
FORMULA | Информационные | ||
FREQUENCY | Массив | ||
FTEST | Статистические | ||
FV | Финансовые | ||
FVSCHEDULE | Финансовые | ||
GAMMA | Статистические | ||
GAMMADIST | Статистические | ||
GAMMAINV | Статистические | ||
GAMMALN | Статистические | ||
GAUSS | Статистические | ||
GCD | Математические | ||
GCD_ADD | Математические | ||
GEOMEAN | Статистические | ||
GESTEP | Математические | ||
GROWTH | Массив | ||
HARMEAN | Статистические | ||
HEX2BIN | Дополнительные | ||
HEX2DEC | Дополнительные | ||
HEX2OCT | Дополнительные | ||
HLOOKUP | Электронная таблица | ||
HOUR | Дата/время | ||
HYPERLINK | Электронная таблица | ||
HYPGEOMDIST | Статистические | ||
IF | Логические | ||
IMABS | Дополнительные | ||
IMAGINARY | Дополнительные | ||
IMARGUMENT | Дополнительные | ||
IMCONJUGATE | Дополнительные | ||
IMCOS | Дополнительные | ||
IMDIV | Дополнительные | ||
IMEXP | Дополнительные | ||
IMLN | Дополнительные | ||
IMLOG10 | Дополнительные | ||
IMLOG2 | Дополнительные | ||
IMPOWER | Дополнительные | ||
IMPRODUCT | Дополнительные | ||
IMREAL | Дополнительные | ||
IMSIN | Дополнительные | ||
IMSQRT | Дополнительные | ||
IMSUB | Дополнительные | ||
IMSUM | Дополнительные | ||
INDEX | Электронная таблица | ||
INDIRECT | Электронная таблица | ||
INFO | Электронная таблица | ||
INT | Математические | ||
INTERCEPT | Статистические | ||
INTRATE | Финансовые | ||
IPMT | Финансовые | ||
IRR | Финансовые | ||
ISBLANK | Информационные | ||
ISERR | Информационные | ||
ISERROR | Информационные | ||
ISEVEN | Информационные | ||
ISEVEN | Математические | ||
ISEVEN_ADD | Информационные | ||
ISFORMULA | Информационные | ||
ISLEAPYEAR | Дата/время | ||
ISLOGICAL | Информационные | ||
ISNA | Информационные | ||
ISNONTEXT | Информационные | ||
ISNUMBER | Информационные | ||
ISODD | Информационные | ||
ISODD | Математические | ||
ISODD_ADD | Информационные | ||
ISPMT | Финансовые | ||
ISREF | Информационные | ||
ISTEXT | Информационные | ||
KURT | Статистические | ||
LARGE | Статистические | ||
LCM | Математические | ||
LCM_ADD | Математические | ||
LEFT | Текстовые | ||
LEN | Текстовые | ||
LINEST | Массив | ||
LN | Математические | ||
LOG | Математические | ||
LOG10 | Математические | ||
LOGEST | Массив | ||
LOGINV | Статистические | ||
LOGNORMDIST | Статистические | ||
LOOKUP | Электронная таблица | ||
LOWER | Текстовые | ||
MATCH | Электронная таблица | ||
MAX | Статистические | ||
MAXA | Статистические | ||
MDETERM | Массив | ||
MDURATION | Финансовые | ||
MEDIAN | Статистические | ||
MID | Текстовые | ||
MIN | Статистические | ||
MINA | Статистические | ||
MINUTE | Дата/время | ||
MINVERSE | Массив | ||
MIRR | Финансовые | ||
MMULT | Массив | ||
MOD | Математические | ||
MODE | Статистические | ||
MONTH | Дата/время | ||
MONTHS | Дата/время | ||
MROUND | Математические | ||
MULTINOMIAL | Математические | ||
MUNIT | Массив | ||
N | Информационные | ||
NA | Информационные | ||
NEGBINOMDIST | Статистические | ||
NETWORKDAYS | Дата/время | ||
NOMINAL | Финансовые | ||
NOMINAL_ADD | Финансовые | ||
NORMDIST | Статистические | ||
NORMINV | Статистические | ||
NORMSDIST | Статистические | ||
NORMSINV | Статистические | ||
NOT | Логические | ||
NOW | Дата/время | ||
NPER | Финансовые | ||
NPV | Финансовые | ||
OCT2BIN | Дополнительные | ||
OCT2DEC | Дополнительные | ||
OCT2HEX | Дополнительные | ||
ODD | Математические | ||
ODDFPRICE | Финансовые | ||
ODDFYIELD | Финансовые | ||
ODDLPRICE | Финансовые | ||
ODDLYIELD | Финансовые | ||
OFFSET | Электронная таблица | ||
OR | Логические | ||
PEARSON | Статистические | ||
PERCENTILE | Статистические | ||
PERCENTRANK | Статистические | ||
PERMUT | Статистические | ||
PERMUTATIONA | Статистические | ||
PHI | Статистические | ||
PI | Математические | ||
PMT | Финансовые | ||
POISSON | Статистические | ||
POWER | Математические | ||
PPMT | Финансовые | ||
PRICE | Финансовые | ||
PRICEDISC | Финансовые | ||
PRICEMAT | Финансовые | ||
PROB | Статистические | ||
PRODUCT | Математические | ||
PROPER | Текстовые | ||
PV | Финансовые | ||
QUARTILE | Статистические | ||
QUOTIENT | Математические | ||
RADIANS | Математические | ||
RAND | Математические | ||
RANDBETWEEN | Математические | ||
RANK | Статистические | ||
RATE | Финансовые | ||
RECEIVED | Финансовые | ||
REPLACE | Текстовые | ||
REPT | Текстовые | ||
RIGHT | Текстовые | ||
ROMAN | Текстовые | ||
ROUND | Математические | ||
ROUNDDOWN | Математические | ||
ROUNDUP | Математические | ||
ROW | Электронная таблица | ||
ROWS | Электронная таблица | ||
RRI | Финансовые | ||
RSQ | Статистические | ||
SEARCH | Текстовые | ||
SECOND | Дата/время | ||
SERIESSUM | Математические | ||
SHEET | Электронная таблица | ||
SHEETS | Электронная таблица | ||
SIGN | Математические | ||
SIN | Математические | ||
SINH | Математические | ||
SKEW | Статистические | ||
SLN | Финансовые | ||
SLOPE | Статистические | ||
SMALL | Статистические | ||
SQRT | Математические | ||
SQRTPI | Математические | ||
STANDARDIZE | Статистические | ||
STDEV | Статистические | ||
STDEVA | Статистические | ||
STDEVP | Статистические | ||
STDEVPA | Статистические | ||
STEYX | Статистические | ||
STYLE | Электронная таблица | ||
SUBSTITUTE | Текстовые | ||
SUBTOTAL | Математические | ||
SUM | Математические | ||
SUMIF | Математические | ||
SUMPRODUCT | Массив | ||
SUMSQ | Математические | ||
SUMX2MY2 | Массив | ||
SUMX2PY2 | Массив | ||
SUMXMY2 | Массив | ||
SYD | Финансовые | ||
T | Текстовые | ||
TAN | Математические | ||
TANH | Математические | ||
TBILLEQ | Финансовые | ||
TBILLPRICE | Финансовые | ||
TBILLYIELD | Финансовые | ||
TDIST | Статистические | ||
TEXT | Текстовые | ||
TIME | Дата/время | ||
TIMEVALUE | Дата/время | ||
TINV | Статистические | ||
TODAY | Дата/время | ||
TRANSPOSE | Массив | ||
TREND | Массив | ||
TRIM | Текстовые | ||
TRIMMEAN | Статистические | ||
TRUE | Логические | ||
TRUNC | Математические | ||
TTEST | Статистические | ||
TYPE | Информационные | ||
UPPER | Текстовые | ||
VALUE | Текстовые | ||
VAR | Статистические | ||
VARA | Статистические | ||
VARP | Статистические | ||
VARPA | Статистические | ||
VDB | Финансовые | ||
VLOOKUP | Электронная таблица | ||
WEEKDAY | Дата/время | ||
WEEKNUM | Дата/время | ||
WEEKNUM_ADD | Дата/время | ||
WEEKS | Дата/время | ||
WEEKSINYEAR | Дата/время | ||
WEIBULL | Статистические | ||
WORKDAY | Дата/время | ||
XIRR | Финансовые | ||
XNPV | Финансовые | ||
YEAR | Дата/время | ||
YEARFRAC | Дата/время | ||
YEARS | Дата/время | ||
YIELD | Финансовые | ||
YIELDDISC | Финансовые | ||
YIELDMAT | Финансовые | ||
ZTEST | Статистические |