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