Справочник функций Calc
Материал из Forumooo wiki
(Различия между версиями)
Yakov (Обсуждение | вклад) (MODE --> МОДА) |
Bormant (Обсуждение | вклад) (Корректировка имен в Excel) |
||
Строка 68: | Строка 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 Текстовые] | ||
- | | | + | |АРАБСКОЕ |
| | | | ||
|- | |- | ||
Строка 253: | Строка 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 Математические] | ||
- | | | + | |ЧИСЛКОМБА |
| | | | ||
|- | |- | ||
Строка 308: | Строка 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 Статистические] | ||
- | | | + | |СЧЁТЗ |
| | | | ||
|- | |- | ||
Строка 323: | Строка 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 Математические] | ||
- | | | + | |СЧЁТЕСЛИ |
| | | | ||
|- | |- | ||
Строка 433: | Строка 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 Финансовые] | ||
- | | | + | |ДДОБ |
| | | | ||
|- | |- | ||
Строка 696: | Строка 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 Финансовые] | ||
- | | | + | |БС |
| | | | ||
|- | |- | ||
Строка 916: | Строка 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 Финансовые] | ||
- | | | + | |ВСД |
| | | | ||
|- | |- | ||
Строка 986: | Строка 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 Математические] | ||
- | | | + | |ЕНЕЧЁТ |
| | | | ||
|- | |- | ||
Строка 1066: | Строка 1066: | ||
| [[Calc/Functions/LOGEST | LOGEST]] | | [[Calc/Functions/LOGEST | LOGEST]] | ||
|[http://help.libreoffice.org/Calc/Array_Functions/ru Массив] | |[http://help.libreoffice.org/Calc/Array_Functions/ru Массив] | ||
- | | | + | |ЛГРФПРИБЛ |
| | | | ||
|- | |- | ||
Строка 1256: | Строка 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 Финансовые] | ||
- | | | + | |ЧПС |
| | | | ||
|- | |- | ||
Строка 1301: | Строка 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 Электронная таблица] | ||
- | | | + | |СМЕЩ |
| | | | ||
|- | |- | ||
Строка 1331: | Строка 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 Статистические] | ||
- | | | + | |ПЕРЕСТА |
| | | | ||
|- | |- | ||
Строка 1346: | Строка 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 Финансовые] | ||
- | | | + | |ПЛТ |
| | | | ||
|- | |- | ||
Строка 1361: | Строка 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 Финансовые] | ||
- | | | + | |ОСПЛТ |
| | | | ||
|- | |- | ||
Строка 1386: | Строка 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 Математические] | ||
- | | | + | |ПРОИЗВ |
| | | | ||
|- | |- | ||
Строка 1396: | Строка 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 Финансовые] | ||
- | | | + | |ПС |
| | | | ||
|- | |- | ||
Строка 1456: | Строка 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 Текстовые] | ||
- | | | + | |РИМСКОЕ |
| | | | ||
|- | |- | ||
Строка 1541: | Строка 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 Финансовые] | ||
- | | | + | |АПЛ |
| | | | ||
|- | |- | ||
Строка 1646: | Строка 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 Финансовые] | ||
- | | | + | |АСЧ |
| | | | ||
|- | |- | ||
Строка 1696: | Строка 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 Дата/время] | ||
- | | | + | |ВРЕМЗНАЧ |
| | | | ||
|- | |- | ||
Строка 1781: | Строка 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 Финансовые] | ||
- | | | + | |ПУО |
| | | | ||
|- | |- | ||
Строка 1791: | Строка 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 Дата/время] | ||
- | | | + | |ДЕНЬНЕД |
| | | | ||
|- | |- |
Текущая версия на 11:03, 19 февраля 2017