Справочник функций Calc
Материал из Forumooo wiki
(Различия между версиями)
Yakov (Обсуждение | вклад) м |
Bormant (Обсуждение | вклад) (Корректировка имен в Excel) |
||
(4 промежуточные версии не показаны) | |||
Строка 1: | Строка 1: | ||
{{DISPLAYTITLE:Справочник функций Calc}} | {{DISPLAYTITLE:Справочник функций Calc}} | ||
+ | |||
+ | |||
+ | {{Tip|Если есть два варианта записи функции, то вариант функций имена которых заканчиваются на _ADD, возвращают те же результаты, что и соответствующие функции Excel. Функции без _ADD используются для получения результатов на основе международных стандартов.}} | ||
+ | |||
{| class="prettytable sortable" border="0" | {| class="prettytable sortable" border="0" | ||
Строка 64: | Строка 68: | ||
| [[Calc/Functions/ARABIC | ARABIC]] | | [[Calc/Functions/ARABIC | ARABIC]] | ||
|[http://help.libreoffice.org/Calc/Text_Functions/ru Текстовые] | |[http://help.libreoffice.org/Calc/Text_Functions/ru Текстовые] | ||
- | | | + | |АРАБСКОЕ |
| | | | ||
|- | |- | ||
Строка 74: | Строка 78: | ||
| [[Calc/Functions/ASIN | ASIN]] | | [[Calc/Functions/ASIN | ASIN]] | ||
|[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | |[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 Математические] | |[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 Математические] | |[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 Математические] | |[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 Математические] | |[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | ||
- | | | + | |ATANH |
| | | | ||
|- | |- | ||
Строка 249: | Строка 253: | ||
| [[Calc/Functions/COMBINA | COMBINA]] | | [[Calc/Functions/COMBINA | COMBINA]] | ||
|[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | |[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | ||
- | | | + | |ЧИСЛКОМБА |
| | | | ||
|- | |- | ||
Строка 304: | Строка 308: | ||
| [[Calc/Functions/COUNT | COUNT]] | | [[Calc/Functions/COUNT | COUNT]] | ||
|[http://help.libreoffice.org/Calc/Statistics_Functions/ru Статистические] | |[http://help.libreoffice.org/Calc/Statistics_Functions/ru Статистические] | ||
- | | | + | |СЧЁТ |
| | | | ||
|- | |- | ||
| [[Calc/Functions/COUNTA | COUNTA]] | | [[Calc/Functions/COUNTA | COUNTA]] | ||
|[http://help.libreoffice.org/Calc/Statistics_Functions/ru Статистические] | |[http://help.libreoffice.org/Calc/Statistics_Functions/ru Статистические] | ||
- | | | + | |СЧЁТЗ |
| | | | ||
|- | |- | ||
Строка 319: | Строка 323: | ||
| [[Calc/Functions/COUNTIF | COUNTIF]] | | [[Calc/Functions/COUNTIF | COUNTIF]] | ||
|[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | |[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | ||
- | | | + | |СЧЁТЕСЛИ |
| | | | ||
|- | |- | ||
Строка 429: | Строка 433: | ||
| [[Calc/Functions/DB | DB]] | | [[Calc/Functions/DB | DB]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[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 База данных] | |[http://help.libreoffice.org/Calc/Database_Functions/ru База данных] | ||
- | | | + | |БСЧЁТ |
| | | | ||
|- | |- | ||
| [[Calc/Functions/DCOUNTA | DCOUNTA]] | | [[Calc/Functions/DCOUNTA | DCOUNTA]] | ||
|[http://help.libreoffice.org/Calc/Database_Functions/ru База данных] | |[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 Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |ДДОБ |
| | | | ||
|- | |- | ||
Строка 692: | Строка 696: | ||
| [[Calc/Functions/FV | FV]] | | [[Calc/Functions/FV | FV]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |БС |
| | | | ||
|- | |- | ||
Строка 912: | Строка 916: | ||
| [[Calc/Functions/IPMT | IPMT]] | | [[Calc/Functions/IPMT | IPMT]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[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 Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |ВСД |
| | | | ||
|- | |- | ||
Строка 982: | Строка 986: | ||
| [[Calc/Functions/ISODD | ISODD]] | | [[Calc/Functions/ISODD | ISODD]] | ||
|[http://help.libreoffice.org/Calc/Information_Functions/ru Информационные] | |[http://help.libreoffice.org/Calc/Information_Functions/ru Информационные] | ||
- | | | + | |ЕНЕЧЁТ |
| | | | ||
|- | |- | ||
| [[Calc/Functions/ISODD | ISODD]] | | [[Calc/Functions/ISODD | ISODD]] | ||
|[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | |[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | ||
- | | | + | |ЕНЕЧЁТ |
| | | | ||
|- | |- | ||
Строка 1047: | Строка 1051: | ||
| [[Calc/Functions/LN | LN]] | | [[Calc/Functions/LN | LN]] | ||
|[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | |[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 Математические] | |[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 Математические] | |[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 Массив] | |[http://help.libreoffice.org/Calc/Array_Functions/ru Массив] | ||
- | | | + | |ЛГРФПРИБЛ |
| | | | ||
|- | |- | ||
Строка 1157: | Строка 1161: | ||
| [[Calc/Functions/MODE | MODE]] | | [[Calc/Functions/MODE | MODE]] | ||
|[http://help.libreoffice.org/Calc/Statistics_Functions/ru Статистические] | |[http://help.libreoffice.org/Calc/Statistics_Functions/ru Статистические] | ||
- | | | + | |МОДА |
| | | | ||
|- | |- | ||
Строка 1252: | Строка 1256: | ||
| [[Calc/Functions/NPV | NPV]] | | [[Calc/Functions/NPV | NPV]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |ЧПС |
| | | | ||
|- | |- | ||
Строка 1297: | Строка 1301: | ||
| [[Calc/Functions/OFFSET | OFFSET]] | | [[Calc/Functions/OFFSET | OFFSET]] | ||
|[http://help.libreoffice.org/Calc/Spreadsheet_Functions/ru Электронная таблица] | |[http://help.libreoffice.org/Calc/Spreadsheet_Functions/ru Электронная таблица] | ||
- | | | + | |СМЕЩ |
| | | | ||
|- | |- | ||
Строка 1327: | Строка 1331: | ||
| [[Calc/Functions/PERMUTATIONA | PERMUTATIONA]] | | [[Calc/Functions/PERMUTATIONA | PERMUTATIONA]] | ||
|[http://help.libreoffice.org/Calc/Statistics_Functions/ru Статистические] | |[http://help.libreoffice.org/Calc/Statistics_Functions/ru Статистические] | ||
- | | | + | |ПЕРЕСТА |
| | | | ||
|- | |- | ||
Строка 1342: | Строка 1346: | ||
| [[Calc/Functions/PMT | PMT]] | | [[Calc/Functions/PMT | PMT]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |ПЛТ |
| | | | ||
|- | |- | ||
Строка 1357: | Строка 1361: | ||
| [[Calc/Functions/PPMT | PPMT]] | | [[Calc/Functions/PPMT | PPMT]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |ОСПЛТ |
| | | | ||
|- | |- | ||
Строка 1382: | Строка 1386: | ||
| [[Calc/Functions/PRODUCT | PRODUCT]] | | [[Calc/Functions/PRODUCT | PRODUCT]] | ||
|[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | |[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | ||
- | | | + | |ПРОИЗВ |
| | | | ||
|- | |- | ||
Строка 1392: | Строка 1396: | ||
| [[Calc/Functions/PV | PV]] | | [[Calc/Functions/PV | PV]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |ПС |
| | | | ||
|- | |- | ||
Строка 1452: | Строка 1456: | ||
| [[Calc/Functions/ROMAN | ROMAN]] | | [[Calc/Functions/ROMAN | ROMAN]] | ||
|[http://help.libreoffice.org/Calc/Text_Functions/ru Текстовые] | |[http://help.libreoffice.org/Calc/Text_Functions/ru Текстовые] | ||
- | | | + | |РИМСКОЕ |
| | | | ||
|- | |- | ||
Строка 1537: | Строка 1541: | ||
| [[Calc/Functions/SLN | SLN]] | | [[Calc/Functions/SLN | SLN]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |АПЛ |
| | | | ||
|- | |- | ||
Строка 1602: | Строка 1606: | ||
| [[Calc/Functions/SUBTOTAL | SUBTOTAL]] | | [[Calc/Functions/SUBTOTAL | SUBTOTAL]] | ||
|[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | |[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | ||
- | | | + | |ПРОМЕЖУТОЧНЫЕ.ИТОГИ |
| | | | ||
|- | |- | ||
Строка 1642: | Строка 1646: | ||
| [[Calc/Functions/SYD | SYD]] | | [[Calc/Functions/SYD | SYD]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |АСЧ |
| | | | ||
|- | |- | ||
Строка 1652: | Строка 1656: | ||
| [[Calc/Functions/TAN | TAN]] | | [[Calc/Functions/TAN | TAN]] | ||
|[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | |[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 Математические] | |[http://help.libreoffice.org/Calc/Mathematical_Functions/ru Математические] | ||
- | | | + | |TANH |
| | | | ||
|- | |- | ||
Строка 1692: | Строка 1696: | ||
| [[Calc/Functions/TIMEVALUE | TIMEVALUE]] | | [[Calc/Functions/TIMEVALUE | TIMEVALUE]] | ||
|[http://help.libreoffice.org/Calc/Date_and_Time_Functions/ru Дата/время] | |[http://help.libreoffice.org/Calc/Date_and_Time_Functions/ru Дата/время] | ||
- | | | + | |ВРЕМЗНАЧ |
| | | | ||
|- | |- | ||
Строка 1777: | Строка 1781: | ||
| [[Calc/Functions/VDB | VDB]] | | [[Calc/Functions/VDB | VDB]] | ||
|[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | |[http://help.libreoffice.org/Calc/Financial_Functions_Part_One/ru Финансовые] | ||
- | | | + | |ПУО |
| | | | ||
|- | |- | ||
Строка 1787: | Строка 1791: | ||
| [[Calc/Functions/WEEKDAY | WEEKDAY]] | | [[Calc/Functions/WEEKDAY | WEEKDAY]] | ||
|[http://help.libreoffice.org/Calc/Date_and_Time_Functions/ru Дата/время] | |[http://help.libreoffice.org/Calc/Date_and_Time_Functions/ru Дата/время] | ||
- | | | + | |ДЕНЬНЕД |
| | | | ||
|- | |- | ||
Строка 1869: | Строка 1873: | ||
---- | ---- | ||
- | |||
- |
Текущая версия на 11:03, 19 февраля 2017