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