Spread32 Help
(C) 2001 Bye Design Ltd
BasicsA spreadsheet file is made up of pages, called "sheets". There are different types of sheets: Worksheets - which are used for storing data and doing calculations, Chart sheets - which are used for displaying graphs and charts, and Macro sheets - which are used for storing the instructions that make up custom (user-defined) functions and commands.
A worksheet consists of many boxes, called "cells", arranged in a grid. There are 65536 rows and 256 columns of these. The rows are number from 1 to 65536, and the columns are named after the letters of the alphabet, going from A to Z, then AA, AB ... AZ, BA, BB ... etc all the way up to IV, which is the 256th column.
An individual row is referred to by its row number, an individual column is referred to by its column name, and an individual cell is referred to by the column name and row number that it is in. For example the cell in the top left corner of a worksheet is referred to as cell A1, because it is in column A and row 1.
The sheets are referred to by their sheet names. When new sheets are added they are given default names such as Sheet1, Sheet2 etc. You can change these names by using the Формат Лист Переименовать menu option. The sheet names are displayed on tabs at the bottom of the screen. To select a particular sheet to be displayed, either tap on the sheet name tab, or use the arrow buttons in the bottom left corner.
The currently active, or 'cursor' cell is displayed with a thick black border around it. If there is a formula in this cell then it will be displayed in the formula bar at the top of the screen, and if you want to enter a formula then this is the cell where the formula will be stored. To move the cursor to a different cell you can use the up/down/left/right arrow keys on your keyboard, or use your mouse or pointer to click on a different cell.
Most operations on the spreadsheet affect the currently selected cells, called the selection. Normally there is only one cell selected, that is the cursor cell. For many operations you will want to select more than one cell. You can do this by moving the cursor to one corner of the area to be selected (see above) and then either hold down the shift key and use the arrow keys to extend the selection as far as necessary, or drag your mouse or pointer across the screen to the far corner of the area to be selected. The selected cells will be displayed with their colours reversed.
| Создать | Opens a new blank workbook. |
| Открыть | Displays the File Open dialog box for you to choose a spreadsheet file to open. |
| Список | Displays a list of the 9 most recently used (i.e. opened or saved) files as a shortcut for opening them. |
| Закрыть | Closes the current workbook, after prompting you to save any changes. |
| Сохранить | Saves the current workbook back into the file it was opened from. If this spreadsheet was created with the Файл Создать menu option rather than opened with the Файл Открыть menu option, then you will be asked for a file name to save it under. |
| Сохранить как | Displays the File Save dialog box for you to choose a name and location for saving the current workbook. |
| Окно | Displays a list of the currently open workbooks and allows you to select a different one as the active workbook. |
| Печать | Prints the currently displayed sheet. |
| Выход | This shuts down the program, after prompting you to save any changed workbooks. |
| Отменить | This option undoes the last change you made to the spreadsheet, should you make a mistake or just change your mind. There are currently 16 levels of Undo, that is, the program remembers the last 16 things that you did and can step back through them using this menu option. | ||||||||||
| Вырезать | This option removes the contents of the currently selected cells and places them on the clipboard, so that you can paste them somewhere else. Only one selection can be stored on the clipboard at a time, so this will replace whatever was previously on the clipboard. | ||||||||||
| Копировать | This option copies the contents of the currently selected cells and places them on the clipboard, so that you can paste them somewhere else. Only one selection can be stored on the clipboard at a time, so this will replace whatever was previously on the clipboard. | ||||||||||
| Вставить | This option takes the contents of the clipboard and puts it into the currently selected cells. | ||||||||||
| Специальная вставка | When cells are cut or copied to the clipboard, the program stores not only what is displayed in the cell, but also the formula that is in the cell and the formatting. The Вставить menu option will paste all of this information into the target cells, but this menu option allows you to paste just some of that information. A dialog box is displayed for you to choose what is pasted. | ||||||||||
| Заполнение |
| ||||||||||
| Очистить |
| ||||||||||
| Удалить | If entire rows or columns have been selected then this menu option will delete the selected rows or columns. Otherwise (that is, one or more cells have been selected) a dialog box will be displayed containing 4 options: (1) со сдвигом влево - delete the selected cells and move the cells on the right of them to the left to take their places, (2) со сдвигом вверх - delete the selected cells and move the cells below them up to take their places, (3) строку - delete the entire rows that the selection spans, the rows below will be moved up, (4) столбец - delete the entire columns that the selection spans, the columns to the right will be moved left. | ||||||||||
| Удалить лист | Delete the currently displayed worksheet, chart or macro sheet. If there is only one worksheet in your spreadsheet file, you will not be allowed to delete it. | ||||||||||
| Переместить/скопировать лист | Allows you to move or copy the current sheet to a different position in the file. | ||||||||||
| Найти | Allows you to look for cells that contain specified things. This menu option displays a dialog box asking you 4 things: (1) the text that you want to search for, (2) whether to look for it in the formulas (what was typed into the cells) or in the values (what is displayed in the cells), (3) whether the search is to be case-sensitive (whether you want upper and lower case letters to be treated as different), and (4) whether to find cells that are equal to the text that you typed or just contain the text that you typed. Entering these and pressing Найти далее will move the cursor to the first cell after the current cursor position that matches your request. The dialog box stays on the screen until it is cancelled, so repeated pressing of the Найти далее button will take you to each of the cells that match your request. | ||||||||||
| Заменить | Allows you to search for text in cell formulas and optionally replace one or all occurrences. | ||||||||||
| Перейти | Allows you to move directly to another part of the worksheet. This menu option displays a dialog box that asks you for a cell reference. Entering the reference and pressing ОК will move the cursor to the specified cell. |
| Ячейки | If entire rows or columns have been selected then this menu option will insert the selected rows or columns. Otherwise (that is, one or more cells have been selected) a dialog box will be displayed containing 4 options: (1) со сдвигом вправо - the cells to the right of the selection will be moved to the right to make room for the new cells, (2) со сдвигом вниз - the cells below the selection will be moved down to make room for the new cells, (3) строку - the entire rows that the selection spans will be inserted, (4) столбец - the entire columns that the selection spans will be inserted. | ||||||||||||||||||
| Строки | Inserts one or more new rows where the selection is. | ||||||||||||||||||
| Столбцы | Inserts one or more new columns where the selection is. | ||||||||||||||||||
| Лист | Inserts a blank worksheet at the end of the spreadsheet file. | ||||||||||||||||||
| Диаграмма |
| ||||||||||||||||||
| Макрос | Inserts a blank macro sheet at the end of the spreadsheet file. Macro sheets are used for storing custom (user-defined) functions and commands. | ||||||||||||||||||
| Функция | Displays a dialog box from which you can select a function to be inserted into the current cell formula. | ||||||||||||||||||
| Имя |
| ||||||||||||||||||
| Примечание | This option allows you to add a comment to the currently selected cell. If there is already a comment attached to the cell, then this option will be changed to Изменить примечание, and the existing comment will be displayed for you to change. You can press the Escape key to leave without entering or changing the comment, or you can click outside the comment box to save the changes. When a cell contains a comment, there will be a comment indicator in the top-right corner of the cell. To display a comment you can either use this menu option, or you can click and hold the pointer on the cell for 1/2 a second, the comment will be displayed until you move or release the pointer. To remove a comment from a cell, use the Правка Очистить Примечания menu option. | ||||||||||||||||||
| Элемент управления |
| ||||||||||||||||||
| Графический объект |
|
| Ячейки | Displays a dialog box that allows you to change the way that the contents of the selected cells are displayed. You can change the way that numbers, amounts of money, dates, times and text are formatted. You can change the colour of the text, the pattern and colour of the cell background, and the type and colour of the cell borders. | ||||||||||||||||||
| Строка |
| ||||||||||||||||||
| Столбец |
| ||||||||||||||||||
| Лист |
| ||||||||||||||||||
| Файл | Allows you to select whether the Vertical scrollbar, Horizontal scrollbar and Sheet tabs are to be displayed for sheets in the current file. | ||||||||||||||||||
| Программа | Allows you to select whether the Toolbar, Formula bar and Status bar are to be displayed by the program. | ||||||||||||||||||
| Условное | Allows you to select alternative formatting for cells depending on conditions. | ||||||||||||||||||
| Закрепить | On a worksheet, this allows you to fix the currently displayed row and/or column headings so that they will not move when the sheet is scrolled. When you use this option, the rows above the cursor cell and the columns to the left of it will be fixed. For example, if you want the top row to stay the same when you page down through the sheet, move the cursor to cell A2 and then use this menu option, the row above cell A2, which is row 1, will stay displayed when you page through the sheet, and as there are no columns to the left of cell A2, no columns will be fixed. When this option has been used, the menu option changes to Снять закрепление which allows you to free the rows and columns again. | ||||||||||||||||||
| Данные |
| ||||||||||||||||||
| Диаграмма | On a chart sheet, this displays a dialog box that allows you to change the type of the chart, the data that is used, and the way in which the chart is formatted. | ||||||||||||||||||
| Элемент управления | Displays a dialog box that allows you to set the attributes of the currently selected Control object. | ||||||||||||||||||
| Графический объект | Displays a dialog box that allows you to set the attributes of the currently selected Drawing object. |
To enter text or number information into the spreadsheet, just move the cursor to the required cell, type the text or number in the formula bar and press the enter key. In most spreadsheets you will want to do some calculations with this text and number information. This is done using formulas. Formulas are entered into cells using an equal sign followed by the expression to be evaluated. The result of the calculation will be displayed in the cell that contains the formula. Examples:
| =2+2 | Will display the value 4. |
| ="Hello " & "world!" | Will display Hello world!. |
| =СУММ(A1:A10) | Will add up the values in cells A1 to A10 and display the total. |
Note that although you will usually see function names (like СУММ above) in upper case, you can enter them in upper or lower case. The same applies to cell names, you could enter A1 or a1 to refer to the top left cell.
Many formulas, like СУММ, allow you to specify not just one cell but a whole block of cells as a parameter. This is done by specifying the name of the cell at one corner of the block, followed by a colon, followed by the name of the cell at the opposite corner. For example the 2x2 square of cells in the top left corner of a worksheet could be specified by A1:B2 (or A2:B1, or B1:A2 etc, it doesn't matter which corner is specified first).
To refer to cells on other sheets, prefix the cell or range reference with the sheet name followed by an exclamation mark, for example Sheet1!A1 or Sheet1!A1:B2. If the sheet name contains spaces, you will need to put it in single quotes, like this: 'Other sheet'!A1.
Some formulas, such as =МУМНОЖ(A1:B2,C1:D2) (which multiplies two matrices together), can return more than one value. These are called Array formulas. To use these, you will first need to select a block of cells of the correct size and shape for the expected results, then type your formula into the formula bar, and enter it not by pressing the Enter key, but by holding down the Shift and Control keys and then pressing the Enter key. This tells the program that this is an Array formula.
Работа с базой данных functions
[ ] indicates optional parameters
БДДИСП(база_данных, поле, критерий)[ ] indicates optional parameters
ВРЕМЗНАЧ(время_как_текст)[ ] indicates optional parameters
БЕССЕЛЬ.I(x, n)[ ] indicates optional parameters
TTBILLEQ(settlement_date, maturity_date, discount)Проверка свойств и значений functions
[ ] indicates optional parameters
ЕЛОГИЧ(значение)[ ] indicates optional parameters
ЕСЛИ(логическое_выражение, [значение_если_истина], [значение_если_ложь])[ ] indicates optional parameters
АДРЕС(номер_строки, номер_столбца, [абсолютный_номер], [а1], [текст_листа])[ ] indicates optional parameters
ABS(число)[ ] indicates optional parameters
FРАСП(x, степени_свободы1, степени_свободы2)[ ] indicates optional parameters
ДЛСТР(текст)Управление макросами functions
[ ] indicates optional parameters
АРГУМЕНТ([строка_имени], [номер_типа_данных], [ссылка])[ ] indicates optional parameters
АКТИВИЗИРОВАТЬ([заголовок_окна], [номер_подокна])[ ] indicates optional parameters
ВЫЗВАТЬ(имя_модуля, процедура, тип, [аргумент1, ...])БДДИСП(база_данных, поле, критерий)
Returns the variance (based on a population sample) of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values of which you want to find the variance. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
БДДИСПП(база_данных, поле, критерий)
Returns the variance (based on the entire population) of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values of which you want to find the variance. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
БДПРОИЗВЕД(база_данных, поле, критерий)
Returns the product of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values that you want to multiply together. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
БДСУММ(база_данных, поле, критерий)
Returns the sum of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values of which you want to find the sum. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
БИЗВЛЕЧЬ(база_данных, поле, критерий)
Returns the value of a specified field from the row in the database range that meets the selection criteria. There should be one and only one row that meets the selection criteria. If no rows meet the criteria then the error #ЗНАЧ! is returned. If more than one row meets the criteria then the error #ЧИСЛО! is returned.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the value that you want to retrieve. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
БСЧЁТ(база_данных, [поле], критерий)
Returns the count of the number of rows in the database that meet the selection criteria and where the specified field contains a number.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values that you want to count. If this parameter is omitted then the function will return the number of database rows that meet the selection criteria. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
БСЧЁТА(база_данных, [поле], критерий)
Returns the count of the number of rows in the database that meet the selection criteria and where the specified field is not blank.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values that you want to count. If this parameter is omitted then the function will return the number of database rows that meet the selection criteria. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
ДМАКС(база_данных, поле, критерий)
Returns the maximum of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values of which you want to find the maximum. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
ДМИН(база_данных, поле, критерий)
Returns the minimum of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values of which you want to find the minimum. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
ДСРЗНАЧ(база_данных, поле, критерий)
Returns the average of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values of which you want to find the average. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
ДСТАНДОТКЛ(база_данных, поле, критерий)
Returns the standard deviation (based on a population sample) of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values of which you want to find the standard deviation. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
ДСТАНДОТКЛП(база_данных, поле, критерий)
Returns the standard deviation (based on the entire population) of the values of a specified field in a database range.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the values of which you want to find the standard deviation. |
| критерий | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the база_данных parameter if you want to select all the rows. |
Returns the time value that corresponds to a time in text form. You should not need to use this function, as times are automatically converted from text to time values when they are used in formulas.
| время_как_текст | The time that you want to convert. It can contain time separators and/or AM/PM designators. If seconds or minutes and seconds are not specified then they will default to zero. |
Returns the serial number corresponding to a specified hour, minute and second.
| час | The hour number. Preferably between 0 and 23. |
| минута | The minute number. Preferably between 0 and 59. |
| секунда | The second number. Preferably between 0 and 59. |
Returns the year number (greater than or equal to 1900) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the year number. |
Returns the date value corresponding to a specified year, month and day. Note that only dates from 1900 onwards can be used.
| год | The year number. If you enter a number less than 1900 then 1900 will be added to the value. |
| месяц | The month number. Preferably between 1 and 12. |
| день | The day number. Preferably between 1 and 31. |
Returns the date value that corresponds to a date in text form. Note that only dates from 1900 onwards can be used. You should not need to use this function, as dates are automatically converted from text to date values when they are used in formulas.
| дата_как_текст | The date that you want to convert. It can contain date separators and/or a month name. If only the day and month is supplied then the year will default to the current year. |
ДАТАМЕС(начальная_дата, месяцев)
Returns the date that is the start date plus or minus a number of months.
| начальная_дата | The 'from' date. |
| месяцев | The number of months to be added or subtracted. |
Returns the day number (between 1 and 31) from the specified date value.
| дата_как_число | The date value from which you want to extract the day number. |
ДЕНЬНЕД(дата_как_число, [тип])
Returns a number representing the day of the week of a given date.
| дата_как_число | The date/time value from which you want the day of the week. | ||||||
| тип | The range of values returned and what they represent. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 1. |
ДНЕЙ360(начальная_дата, конечная_дата, [метод])
Returns the number of days between two dates using a 360-day year (30 day months).
| начальная_дата | The 'from' date. | ||||
| конечная_дата | The 'to' date. | ||||
| метод | Indicates how to deal with end dates that are the 31st of the month (the start date will always be moved from the 31st to the 30th). The options are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
ДОЛЯГОДА(начальная_дата, конечная_дата, [basis])
Returns the fraction of a year represented by the difference between two dates.
| начальная_дата | The 'from' date. | ||||||||||
| конечная_дата | The 'to' date. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
КОНМЕСЯЦА(начальная_дата, месяцев)
Returns the date that is the last day of the month calculated from the start date plus or minus a number of months.
| начальная_дата | The 'from' date. |
| месяцев | The number of months to be added or subtracted. |
Returns the month number (between 1 and 12) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the month number. |
Returns the minute number (between 0 and 59) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the minute number. |
НОМНЕДЕЛИ(дата_как_число, [тип])
Returns the week of the year of a given date.
| дата_как_число | The date/time value from which you want the week number. | ||||||
| тип | The method used to calculate the week number. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 1. |
РАБДЕНЬ(начальная_дата, количество_дней, [holidays])
Returns the working day that is the start date plus or minus a number of working days (weekdays), excluding any holidays.
| начальная_дата | The 'from' date. |
| количество_дней | The number of working days to add or subtract. |
| holidays | A date or array of dates or a reference to a list of dates that are to be treated as non-working days. |
Returns the difference between two dates in the units that you specify.
| дата1 | The 'from' date. | ||||||||||||
| дата2 | The 'to' date. This should be greater than or equal to the 'from' date. | ||||||||||||
| единиц | The units in which you want the difference expressed. The possible values are: | ||||||||||||
|
Returns the serial number corresponding to the current date.
Returns the second number (between 0 and 59) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the second number. |
Returns the hour number (between 0 and 23) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the hour number. |
Returns the serial number corresponding to the current date and time.
ЧИСТРАБДНИ(начальная_дата, конечная_дата, [holidays])
Returns the number of working days (weekdays) between the start and end dates, excluding any holidays.
| начальная_дата | The 'from' date. |
| конечная_дата | The 'to' date. |
| holidays | A date or array of dates or a reference to a list of dates that are to be treated as non-working days. |
Returns the value of the modified Bessel function.
| x | The value at which you want to evaluate the function. |
| n | The order of the Bessel function. |
Returns the value of the Bessel function.
| x | The value at which you want to evaluate the function. |
| n | The order of the Bessel function. |
Returns the value of the modified Bessel function.
| x | The value at which you want to evaluate the function. |
| n | The order of the Bessel function. |
Returns the value of the Bessel function.
| x | The value at which you want to evaluate the function. |
| n | The order of the Bessel function. |
Returns a string that is the binary equivalent of an octal number.
| число | The octal number to be converted. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns a number that is the decimal equivalent of an octal number.
| число | The octal number to be converted. |
Returns a string that is the hexadecimal equivalent of an octal number.
| число | The octal number to be converted. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns a string that is the octal equivalent of a binary number.
| число | The binary number to be converted. It can be a number or a string up to 10 (binary) digits long. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns the decimal equivalent of a binary number.
| число | The binary number to be converted. It can be a number or a string up to 10 (binary) digits long. |
Returns a string that is the hexadecimal equivalent of a binary number.
| число | The binary number to be converted. It can be a number or a string up to 10 (binary) digits long. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns the double factorial of a number.
| число | The number of which you want the double factorial. |
Returns 1 if the numbers are equal, otherwise 0.
| число1 | The first of the numbers to be compared. |
| число2 | The second of the numbers to be compared. If this parameter is omitted it defaults to zero. |
Returns a string that is the octal equivalent of a decimal number.
| число | The decimal number to be converted. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns a string that is the binary equivalent of a decimal number.
| число | The decimal number to be converted. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns a string that is the hexadecimal equivalent of a decimal number.
| число | The decimal number to be converted. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns the integral of the error function between a specified limit and infinity.
| x | The lower limit of the integral. |
КОМПЛЕКСН(real_num, imag_num, [suffix])
Returns a string representing an complex number made up of the specified real and imaginary parts.
| real_num | The real part of the complex number. |
| imag_num | The imaginary part of the complex number. |
| suffix | The suffix to be used for the imaginary part. Should be "i" or "j". If this parameter is omitted it defaults to "i". |
Returns a number that is the modulus of a complex number.
| iчисло | The complex number of which you want the modulus. |
Returns a complex number that is the cosine of the specified complex number.
| iчисло | The complex number of which you want the cosine. |
Returns a complex number that is the exponential of the specified complex number.
| iчисло | The complex number of which you want the exponential. |
Returns a complex number that is the natural logarithm of the specified complex number.
| iчисло | The complex number of which you want the natural logarithm. |
Returns a complex number that is the base 10 logarithm of the specified complex number.
| iчисло | The complex number of which you want the base 10 logarithm. |
Returns a complex number that is the base 2 logarithm of the specified complex number.
| iчисло | The complex number of which you want the base 2 logarithm. |
Returns a complex number that is the sine of the specified complex number.
| iчисло | The complex number of which you want the sine. |
Returns a number that is the angle (in radians) represented by a complex number.
| iчисло | The complex number of which you want the argument. |
Returns a number that is the real part of a complex number.
| iчисло | The complex number of which you want the real part. |
Returns a complex number that is the quotient of the specified complex numbers.
| iчисло1 | The dividend complex number. |
| iчисло2 | The divisor complex number. |
Returns a complex number that is the square root of the specified complex number.
| iчисло | The complex number of which you want the square root. |
МНИМ.ПРОИЗВЕД(iчисло1, [iчисло2, ...])
Returns a complex number that is the product of the specified complex numbers.
| iчисло1, ... | The complex numbers that you want to multiply together. |
Returns a complex number that is the difference of the specified complex numbers.
| iчисло1 | The minuend complex number. |
| iчисло2 | The subtrahend complex number. |
Returns a complex number that is the conjugate of the specified complex number.
| iчисло | The complex number of which you want the conjugate. |
Returns a complex number that is the specified complex number raised to a power.
| iчисло | The complex number that you want to raise to a power. |
| степень | The power to which you want to raise the complex number. |
МНИМ.СУММ(iчисло1, [iчисло2, ...])
Returns a complex number that is the sum of the specified complex numbers.
| iчисло1, ... | The complex numbers that you want to add together. |
Returns a number that is the imaginary part of a complex number.
| iчисло | The complex number of which you want the imaginary part. |
Returns 1 if number is greater than or equal to step, otherwise 0.
| число | The first of the numbers to be compared. |
| шаг | The second of the numbers to be compared. If this parameter is omitted it defaults to zero. |
ПРЕОБР(число, from_unit, to_unit)
Returns a value converted from the 'from' units to the 'to' units.
| число | The number to be converted. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| from_unit | The units to convert from. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| to_unit | The units to convert to. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| The from and to units must belong to the same group. The values are case-sensitive and must be entered exactly as shown. The possible values are: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Weight and mass | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Distance | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Time | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Pressure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Force | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Energy | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Power | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Magnetism | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Temperature | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Liquid measure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
ФОШ(нижний_предел, [верхний_пред])
Returns the integral of the error function between specified limits, or between zero and a specified limit.
| нижний_предел | The lower limit of the integral. |
| верхний_пред | The upper limit of the integral. If this parameter is omitted integration is done between 0 and lower_limit. |
Returns a string that is the octal equivalent of a hexadecimal number.
| число | The hexadecimal number to be converted. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns a string that is the binary equivalent of a hexadecimal number.
| число | The hexadecimal number to be converted. |
| длина | The minimum length required in the returned string. If the string is less than this length then it will be padded with leading zeros. If this parameter is omitted it defaults to zero. |
Returns a number that is the decimal equivalent of a hexadecimal number.
| число | The hexadecimal number to be converted. |
TTBILLEQ(settlement_date, maturity_date, discount)
Returns the bond-equivalent yield for a treasury bill.
| settlement_date | The settlement date. |
| maturity_date | The maturity date. |
| discount | The discount rate. |
АМГД(стоимость, ликвидная_стоимость, жизнь, период)
Returns the sum of years depreciation.
| стоимость | The cost. |
| ликвидная_стоимость | The salvage value. |
| жизнь | The total number of periods. |
| период | The period for which you want the depreciation. |
АМОРУВ(cost, purchase_date, first_period_date, salvage, period, rate, [basis])
Returns the depreciation for each accounting period.
| cost | The cost. | ||||||||||
| purchase_date | The purchase date. | ||||||||||
| first_period_date | The end date of the first period. | ||||||||||
| salvage | The salvage value. | ||||||||||
| period | The period for which you want to calculate the depreciation. | ||||||||||
| rate | The depreciation rate. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
АМОРУМ(cost, purchase_date, first_period_date, salvage, period, rate, [basis])
Returns the depreciation for each accounting period.
| cost | The cost. | ||||||||||
| purchase_date | The purchase date. | ||||||||||
| first_period_date | The end date of the first period. | ||||||||||
| salvage | The salvage value. | ||||||||||
| period | The period for which you want to calculate the depreciation. | ||||||||||
| rate | The depreciation rate. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
АМР(стоимость, ликвидная_стоимость, время_амортизации)
Returns the straight line depreciation.
| стоимость | The cost. |
| ликвидная_стоимость | The salvage value. |
| время_амортизации | The total number of periods. |
БЗ(норма, число_периодов, [выплата], [нз], [тип])
Returns the future value of an investment at a fixed rate.
| норма | The interest rate per period. | ||||
| число_периодов | The total number of periods. | ||||
| выплата | The payment amount each period. If this parameter is omitted it is assumed to be zero. | ||||
| нз | The present value. If this parameter is omitted it is assumed to be zero. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
БЗРАСПИС(principal, schedule_range)
Returns the future value of an investment at a variable rate.
| principal | The initial value of the investment. |
| schedule_range | The list (array or reference) of interest rates to be applied. |
ВНДОХ(значения, [предположение])
Returns the internal rate of return.
| значения | The list (array or reference) of payment and income values. |
| предположение | The estimated rate of return. If this parameter is omitted it defaults to 0.1. |
ДАТАКУПОНДО(settlement_date, maturity_date, frequency, [basis])
Returns the coupon date before the settlement date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДАТАКУПОНПОСЛЕ(settlement_date, maturity_date, frequency, [basis])
Returns the next coupon date after the settlement date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДДОБ(стоимость, остаточная_стоимость, время_эксплуатации, период, [коэффициент])
Returns the depreciation in a specified period using the double declining balance method.
| стоимость | The cost. |
| остаточная_стоимость | The salvage value. |
| время_эксплуатации | The total number of periods. |
| период | The period number for which to calculate depreciation. |
| коэффициент | The rate at which the balance declines. If this parameter is omitted it defaults to 2. |
ДЛИТ(settlement_date, maturity_date, coupon, yield, frequency, [basis])
Returns the Macauley duration for a value of $100.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| coupon | The interest rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДНЕЙКУПОН(settlement_date, maturity_date, frequency, [basis])
Returns the number of days in the coupon period that contains the settlement date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДНЕЙКУПОНДО(settlement_date, maturity_date, frequency, [basis])
Returns the number of days from the beginning of the coupon period to the settlement date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДНЕЙКУПОНПОСЛЕ(settlement_date, maturity_date, frequency, [basis])
Returns the number of days from the settlement date to the next coupon date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОБ(стоимость, остаточная_стоимость, время_эксплуатации, период, [месяц])
Returns the depreciation in a specified period using the fixed declining balance method.
| стоимость | The cost. |
| остаточная_стоимость | The salvage value. |
| время_эксплуатации | The total number of periods. |
| период | The period number for which to calculate depreciation. |
| месяц | The number of months in the first year. If this parameter is omitted it defaults to 12. |
ДОХОД(settlement_date, maturity_date, rate, price, redemption, frequency, [basis])
Returns the yield on a security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| price | The price per $100. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОХОДКЧЕК(settlement_date, maturity_date, price)
Returns the yield for a treasury bill.
| settlement_date | The settlement date. |
| maturity_date | The maturity date. |
| price | The price per $100. |
ДОХОДПЕРВНЕРЕГ(settlement_date, maturity_date, issue_date, first_coupon_date, rate, price, redemption, frequency, [basis])
Returns the yield of a security having an odd (short or long) first period.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| issue_date | The issue date. | ||||||||||
| first_coupon_date | The first coupon date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| price | The price per $100. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОХОДПОГАШ(settlement_date, maturity_date, issue_date, rate, price, [basis])
Returns the annual yield of a security that pays interest at maturity.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| issue_date | The issue date. | ||||||||||
| rate | The interest rate. | ||||||||||
| price | The price per $100. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОХОДПОСЛНЕРЕГ(settlement_date, maturity_date, last_coupon_date, rate, price, redemption, frequency, [basis])
Returns the yield of a security having an odd (short or long) last period.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| last_coupon_date | The last coupon date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| price | The price per $100. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОХОДСКИДКА(settlement_date, maturity_date, price, redemption, [basis])
Returns the annual yield for a discounted security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| price | The price per $100. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ИНОРМА(settlement_date, maturity_date, investment_amount, redemption_amount, [basis])
Returns the interest rate for a fully invested security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| investment_amount | The initial value. | ||||||||||
| redemption_amount | The final value. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
КПЕР(норма, выплата, нз, [бс], [тип])
Returns the number of periods required for an investment.
| норма | The interest rate per period. | ||||
| выплата | The payment amount per period. | ||||
| нз | The present value. | ||||
| бс | The future value. If this parameter is omitted it defaults to 0. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
МВСД(значения, финансовая_норма, реинвест_норма)
Returns the modified internal rate of return.
| значения | The list (array or reference) of payment and income values. |
| финансовая_норма | The interest rate on the payment values. |
| реинвест_норма | The interest rate on the income values. |
МДЛИТ(settlement_date, maturity_date, coupon, yield, frequency, [basis])
Returns the modified Macauley duration for a value of $100.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| coupon | The interest rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
НАКОПДОХОД(issue_date, first_interest_date, settlement_date, rate, par, frequency, [basis])
Returns accrued interest for a security that pays periodic interest.
| issue_date | The issue date. | ||||||||||
| first_interest_date | The first interest date. | ||||||||||
| settlement_date | The settlement date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| par | The par value. | ||||||||||
| frequency | The number of interest payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
НАКОПДОХОДПОГАШ(issue_date, maturity_date, rate, [par], [basis])
Returns accrued interest for a security that pays interest at maturity.
| issue_date | The issue date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| par | The par value. If this parameter is omitted it defaults to 1000. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
Returns the nominal annual interest rate.
| effect_rate | The effective annual interest rate. |
| npery | The number of compound interest payments per year. |
НОРМА(кпер, выплата, нз, [бс], [тип], [предположение])
Returns the interest rate per period of an annuity.
| кпер | The total number of periods. | ||||
| выплата | The payment amount each period. | ||||
| нз | The present value. | ||||
| бс | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. | |||||
| предположение | The estimated rate of return. If this parameter is omitted it defaults to 0.1. |
НПЗ(норма, значение1, [значение2, ...])
Returns the net present value of an investment.
| норма | The discount rate per period. |
| значение1, ... | The payment and income amounts. |
ОБЩДОХОД(норма, кпер, нз, нач_период, кон_период, тип)
Returns the cumulative principal paid on a loan in the specified periods.
| норма | The interest rate. | ||||
| кпер | The total number of periods. | ||||
| нз | The present value. | ||||
| нач_период | The first period number for which to calculate interest. | ||||
| кон_период | The last period number for which to calculate interest. | ||||
| тип | The timing of the payment. The possible values are: | ||||
|
ОБЩПЛАТ(норма, кпер, нз, нач_период, кон_период, тип)
Returns the cumulative interest paid on a loan in the specified periods.
| норма | The interest rate. | ||||
| кпер | The total number of periods. | ||||
| нз | The present value. | ||||
| нач_период | The first period number for which to calculate interest. | ||||
| кон_период | The last period number for which to calculate interest. | ||||
| тип | The timing of the payment. The possible values are: | ||||
|
ОСНПЛАТ(норма, период, кпер, тс, [бс], [тип])
Returns the payment on the principal for a specified period.
| норма | The interest rate per period. | ||||
| период | The period for which you want the payment amount. | ||||
| кпер | The total number of periods. | ||||
| тс | The present value of the loan. | ||||
| бс | The future value of the loan. If this parameter is omitted it defaults to 0. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
ПДОБ(ликв_стоимость, ост_стоим, время_полн_аморт, нач_период, кон_период, [коэффициент], [без_переключений])
Returns the depreciation in a specified range of periods using the variable declining balance method.
| ликв_стоимость | The cost. | ||||
| ост_стоим | The salvage value. | ||||
| время_полн_аморт | The total number of periods. | ||||
| нач_период | The first period number for which to calculate depreciation. | ||||
| кон_период | The last period number for which to calculate depreciation. | ||||
| коэффициент | The rate at which the balance declines. If this parameter is omitted it defaults to 2. | ||||
| без_переключений | Specifies whether to switch to straight-line depreciation when the straight-line depreciation is greater than the declining balance depreciation. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
ПЗ(норма, кпер, [выплата], [бс], [тип])
Returns the present value of an investment at a fixed rate.
| норма | The interest rate per period. | ||||
| кпер | The total number of periods. | ||||
| выплата | The payment amount each period. If this parameter is omitted it is assumed to be zero. | ||||
| бс | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
ПЛПРОЦ(норма, период, кпер, тс, [бс], [тип])
Returns the interest payment for a given period.
| норма | The interest rate per period. | ||||
| период | The period for which you want the interest amount. | ||||
| кпер | The total number of periods. | ||||
| тс | The present value. | ||||
| бс | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
ПОЛУЧЕНО(settlement_date, maturity_date, investment, discount, [basis])
Returns the amount received at maturity for a fully invested security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| investment | The investment amount. | ||||||||||
| discount | The discount rate. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ППЛАТ(норма, кпер, [нз], [бс], [тип])
Returns the payment amount for a loan.
| норма | The interest rate per period. | ||||
| кпер | The total number of periods. | ||||
| нз | The present value of the loan. If this parameter is omitted it defaults to 0. | ||||
| бс | The future value of the loan. If this parameter is omitted it defaults to 0. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
ПРОЦПЛАТ(норма, период, кпер, тс)
Returns the interest payment for a given period.
| норма | The interest rate per period. |
| период | The period for which you want the interest amount. |
| кпер | The total number of periods. |
| тс | The present value. |
РУБЛЬ.ДЕС(fractional_dollar, fraction)
Returns the decimal equivalent of a dollar price expressed as a fraction.
| fractional_dollar | The value expressed as a fraction. |
| fraction | The fraction denominator. |
РУБЛЬ.ДРОБЬ(decimal_dollar, fraction)
Returns the fraction equivalent of a dollar price expressed as a decimal.
| decimal_dollar | The value expressed as a decimal. |
| fraction | The fraction denominator. |
СКИДКА(settlement_date, maturity_date, pr, redemption, [basis])
Returns the discount rate for a security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| pr | The price per $100 value. | ||||||||||
| redemption | The redemption per $100 value. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНА(settlement_date, maturity_date, rate, yield, redemption, frequency, [basis])
Returns the price per $100 of a security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНАКЧЕК(settlement_date, maturity_date, discount)
Returns the price per $100 for a treasury bill.
| settlement_date | The settlement date. |
| maturity_date | The maturity date. |
| discount | The discount rate. |
ЦЕНАПЕРВНЕРЕГ(settlement_date, maturity_date, issue_date, first_coupon_date, rate, yield, redemption, frequency, [basis])
Returns the price per $100 face value of a security having an odd (short or long) first period.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| issue_date | The issue date. | ||||||||||
| first_coupon_date | The first coupon date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНАПОГАШ(settlement_date, maturity_date, issue_date, rate, yield, [basis])
Returns the price per $100 of a security that pays interest at maturity.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| issue_date | The issue date. | ||||||||||
| rate | The interest rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНАПОСЛНЕРЕГ(settlement_date, maturity_date, last_coupon_date, rate, yield, redemption, frequency, [basis])
Returns the price per $100 face value of a security having an odd (short or long) last period.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| last_coupon_date | The last coupon date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНАСКИДКА(settlement_date, maturity_date, discount, redemption, [basis])
Returns the price per $100 of a discounted security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| discount | The discount rate. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЧИСЛКУПОН(settlement_date, maturity_date, frequency, [basis])
Returns the number of coupon periods between the settlement date and the maturity date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЧИСТВНДОХ(значения, dates_range, [предположение])
Returns the internal rate of return.
| значения | The list (array or reference) of payment and income values. |
| dates_range | The list (array or reference) of the dates of the payment and income values. |
| предположение | The estimated rate of return. If this parameter is omitted it defaults to 0.1. |
ЧИСТНЗ(норма, значения, dates_range)
Returns the net present value of an investment.
| норма | The discount rate per period. |
| значения | The list (array or reference) of payment and income values. |
| dates_range | The list (array or reference) of the dates of the payment and income values. |
Returns the effective annual interest rate.
| nominal_rate | The nominal annual interest rate. |
| npery | The number of compound interest payments per year. |
Returns ИСТИНА if the value is a logical value, otherwise ЛОЖЬ.
| значение | The expression whose result you want to check. |
Returns ИСТИНА if the value is the error #Н/Д, otherwise ЛОЖЬ.
| значение | The expression whose result you want to check. |
Returns ИСТИНА if the value is not a string, otherwise ЛОЖЬ.
| значение | The expression whose result you want to check. |
Returns ИСТИНА if the number is odd, otherwise ЛОЖЬ.
| число | The number you want to check. |
Returns ИСТИНА if the value is an error other than #Н/Д, otherwise ЛОЖЬ.
| значение | The expression whose result you want to check. |
Returns ИСТИНА if the value is an error, otherwise ЛОЖЬ.
| значение | The expression whose result you want to check. |
Returns ИСТИНА if the value is a reference to an empty cell, otherwise ЛОЖЬ.
| значение | The cell whose value you want to check. |
Returns ИСТИНА if the value is a reference, otherwise ЛОЖЬ.
| значение | The expression whose result you want to check. |
Returns ИСТИНА if the value is a string, otherwise ЛОЖЬ.
| значение | The expression whose result you want to check. |
Returns ИСТИНА if the number is even, otherwise ЛОЖЬ.
| число | The number you want to check. |
Returns ИСТИНА if the value is a number, otherwise ЛОЖЬ.
| значение | The expression whose result you want to check. |
Returns information about the current spreadsheet.
| тип_информации | The type of information you want returned. The possible values are: | ||||||||||||||||||||
|
Returns the error value #Н/Д.
Returns the number of blank cells in a range.
| диапазон | The reference of the cells you want to check. |
Returns a number corresponding to the type of the value.
| значение | The value, or cell containing the value, that you want to check. | ||||||||||
| The returned values are: | |||||||||||
|
Returns a number corresponding to the type of the error.
| значение_ошибки | The error value, or cell containing the error value, that you want to check. | ||||||||||||||||
| The returned values are: | |||||||||||||||||
|
Returns a number corresponding to the input value, or 0 if the input value is a string. You should not need to use this function, as values are automatically converted where necessary when they are used in formulas.
| значение | The value you want as a number. |
ЯЧЕЙКА(тип_информации, [ссылка])
Returns information about a worksheet cell.
| тип_информации | The type of information you want returned. The possible values are: | ||||||||||||||||||||||||
| |||||||||||||||||||||||||
| ссылка | The cell about which you want information. If this parameter is omitted it defaults to the cell containing the formula. |
ЕСЛИ(логическое_выражение, [значение_если_истина], [значение_если_ложь])
Returns one of two other values depending no whether the logical test evaluates to ИСТИНА or ЛОЖЬ.
| логическое_выражение | An expression that results in ИСТИНА or ЛОЖЬ. |
| значение_если_истина | The value to be returned of the logical test is ИСТИНА. If this parameter is omitted it defaults to 0. |
| значение_если_ложь | The value to be returned of the logical test is ЛОЖЬ. If this parameter is omitted it defaults to ЛОЖЬ. |
И(логическое1, [логическое2, ...])
Returns ИСТИНА if all of the input values are ИСТИНА.
| логическое1, ... | The values that you want to check. |
ИЛИ(логическое1, [логическое2, ...])
Returns ИСТИНА if any of the input values are ИСТИНА.
| логическое1, ... | The values that you want to check. |
Returns the logical value ИСТИНА.
Returns the logical value ЛОЖЬ.
Returns ИСТИНА if the input expression evaluates to ЛОЖЬ, and vice versa.
| флаг | The logical expression for which you want the opposite value. |
АДРЕС(номер_строки, номер_столбца, [абсолютный_номер], [а1], [текст_листа])
Returns a string containing the specified cell address.
| номер_строки | The row number of the cell. | ||||||||
| номер_столбца | The column number of the cell. | ||||||||
| абсолютный_номер | A number representing whether the row or column are to be absolute or relative. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to 1. | |||||||||
| а1 | Specifies the style of the reference. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to ИСТИНА. | |||||||||
| текст_листа | Optional sheet name with which to prefix the reference. |
ВПР(искомое_значение, табл_массив, номер_индекса_столбца, [диапазон_просмотра])
Returns a value from a vertical table, found by searching for the lookup value in the left column of the table and then returning a value from the same or a different column in the table.
| искомое_значение | The value to be found in the table. | ||||
| табл_массив | A reference containing the table cells. | ||||
| номер_индекса_столбца | The offset of the value to be returned, where 1 is the left column of the table. | ||||
| диапазон_просмотра | Whether to find an approximate or exact match. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
ВЫБОР(номер_индекса, значение1, [значение2, ...])
Returns one of several values depending on the index.
| номер_индекса | The index of the value to be returned, should be in the range 1 to 29. |
| значение1, ... | Up to 29 values, one of which will be chosen to be the result. |
ГИПЕРССЫЛКА(адрес_документа, [имя])
Jumps to a cell or range when this cell is selected.
| адрес_документа | A text expression that evaluates to the form "filename" or "[filename]reference". |
| имя | The text to be displayed in the cell. If this parameter is omitted it defaults to the link location text. |
ГПР(искомое_значение, таблица, номер_строки, [диапазон_просмотра])
Returns a value from a horizontal table, found by searching for the lookup value in the top row of the table and then returning a value from the same or a different row in the table.
| искомое_значение | The value to be found in the table. | ||||
| таблица | A reference containing the table cells. | ||||
| номер_строки | The offset of the value to be returned, where 1 is the top row of the table. | ||||
| диапазон_просмотра | Whether to find an approximate or exact match. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
Returns a reference from the specified text.
| ссылка | A text expression that evaluates to the name of a cell or range of cells. | ||||
| а1 | Specifies the style of the reference. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
ИНДЕКС(ссылка, [номер_строки], [номер_столбца], [номер_области])
Returns a subset of an array or reference.
| ссылка | The array or reference of which you want the subset. |
| номер_строки | The number of the row to return. If this parameter is omitted all rows will be returned. |
| номер_столбца | The number of the column to return. If this parameter is omitted all columns will be returned. |
| номер_области | The number of the area to return when the reference contains more than one area. If this parameter is omitted it defaults to 1. |
Returns the number of areas contained in the reference.
| ссылка | The reference whose areas you want to count. |
ПОИСКПОЗ(искомое_значение, искомый_массив, [тип_сопоставления])
Returns a number representing the position of a value in a table.
| искомое_значение | The value to be found in the table. | ||||||
| искомый_массив | A reference containing the table cells. | ||||||
| тип_сопоставления | Whether to find an approximate or exact match. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 1. |
ПРОСМОТР(искомое_значение, вектор_просмотра, [вектор_результата])
Returns a value from a horizontal or vertical table, found by searching for the lookup value in the top row (for a horizontal table) or left column (for a vertical or square table) of the table and then returning a value from the corresponding position in the result range (if specified) or from the bottom row (for a horizontal table) or right column (for a vertical or square table) of the table.
| искомое_значение | The value to be found in the table. |
| вектор_просмотра | A reference containing the table cells. |
| вектор_результата | The range of cells from which to return a result. If this parameter is not specified the result will be returned from the opposite row or column of the table range. |
СМЕЩ(ссылка, строки, столбцы, [высота], [ширина])
Returns a new reference based on the specified reference.
| ссылка | The reference to be used as a starting point. |
| строки | The number of rows to move the reference up (negative) or down (positive). |
| столбцы | The number of columns to move the reference left (negative) or right (positive). |
| высота | The height of the new reference. If this parameter is omitted it defaults to the height of the old reference. |
| ширина | The width of the new reference. If this parameter is omitted it defaults to the width of the old reference. |
Returns the column number of the reference.
| ссылка | The reference whose column number you want. If this parameter is omitted it defaults to the cell containing the function. |
Returns the row number of the reference.
| ссылка | The reference whose row number you want. If this parameter is omitted it defaults to the cell containing the function. |
Returns the transposition of the specified array or reference.
| массив | The array or reference whose values you want to transpose. |
Returns the number of columns in the reference.
| массив | The reference whose columns you want to count. |
Returns the number of rows in the reference.
| массив | The reference whose rows you want to count. |
Returns the absolute value of a number.
| число | The number for which you want the absolute value. |
Returns the angle in radians corresponding to the arccosine of a number.
| число | The number for which you want the arccosine. |
Returns the angle in radians corresponding to the inverse hyperbolic cosine of a number.
| число | The number for which you want the inverse hyperbolic cosine. |
Returns the angle in radians corresponding to the arcsine of a number.
| число | The number for which you want the arcsine. |
Returns the angle in radians corresponding to the inverse hyperbolic sine of a number.
| число | The number for which you want the inverse hyperbolic sine. |
Returns the angle in radians corresponding to the arctangent of a number.
| число | The number for which you want the arctangent. |
Returns the angle in radians corresponding to a pair of co-ordinates.
| x_num | The x co-ordinate for which you want the angle. |
| y_num | The y co-ordinate for which you want the angle. |
Returns the angle in radians corresponding to the inverse hyperbolic tangent of a number.
| число | The number for which you want the inverse hyperbolic tangent. |
Returns the cosine of an angle.
| число | The angle for which you want the cosine. It must be specified in radians. |
Returns the hyperbolic cosine of an angle.
| число | The angle for which you want the hyperbolic cosine. It must be specified in radians. |
Returns the e raised to the power number.
| число | The power to which you want to raise e. |
Returns the natural logarithm of a number.
| число | The number for which you want the natural logarithm. |
LOG(число, [основание_логарифма])
Returns the logarithm of a number in a specified base.
| число | The number for which you want the logarithm. |
| основание_логарифма | The base in which you want the logarithm. If this parameter is omitted it defaults to 10. |
Returns the base 10 logarithm of a number.
| число | The number for which you want the base 10 logarithm. |
Returns the sine of an angle.
| число | The angle for which you want the sine. It must be specified in radians. |
Returns the hyperbolic sine of an angle.
| число | The angle for which you want the hyperbolic sine. It must be specified in radians. |
Returns the tangent of an angle.
| число | The angle for which you want the tangent. It must be specified in radians. |
Returns the hyperbolic tangent of an angle.
| число | The angle for which you want the hyperbolic tangent. It must be specified in radians. |
Converts an angle from radians to degrees.
| угол | The angle that you want to convert. |
Returns the sign of a number; 1 for positive, -1 for negative and 0 for zero.
| число | The number of which you want the sign. |
Returns the square root of a number.
| число | The number of which you want the square root. |
Returns the square root of a number after it is multiplied by Pi.
| число | The number which you want to multiply by Pi and then take the square root. |
Returns the inverse of a matrix.
| массив | An array or reference to cells containing the matrix. |
Returns the determinant of a matrix.
| массив | An array or reference to cells containing the matrix. |
МУЛЬТИНОМ(число1, [число2, ...])
Returns the factorial of the sum of the values divided by the product of their factorials.
| число1, ... | The numbers of which you want the multinomial. |
Returns the product of two matrices.
| массив1 | An array or reference to cells containing the first matrix. |
| массив2 | An array or reference to cells containing the second matrix. |
Returns the number rounded up to the next odd number.
| число | The number which you want rounded. |
Returns the greatest common divisor of a set of numbers.
| число1, ... | The numbers of which you want the greatest common divisor. |
Returns the lowest common multiple of a set of numbers.
| число1, ... | The numbers of which you want the lowest common multiple. |
Returns the number rounded up (away from zero) to the next multiple of significance.
| число | The number which you want rounded. |
| значимость | The units you want to use for rounding. |
Returns the number rounded down (towards zero) to the next multiple of significance.
| число | The number which you want rounded. |
| значимость | The units you want to use for rounding. |
ОКРУГЛ(число, количество_цифр)
Returns a number rounded to the number of decimal places specified.
| число | The number that you want rounded. |
| количество_цифр | The number of decimal places to round to (may be negative). |
ОКРУГЛВВЕРХ(число, [количество_цифр])
Returns a number rounded up to the number of decimal places specified.
| число | The number that you want rounded. |
| количество_цифр | The number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0. |
ОКРУГЛВНИЗ(число, [количество_цифр])
Returns a number rounded down to the number of decimal places specified.
| число | The number that you want rounded. |
| количество_цифр | The number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0. |
Returns the number rounded to a multiple.
| число | The number that you want rounded. |
| multiple | The multiple to which you want the number rounded. |
Returns the remainder of a division.
| число | The dividend. |
| делитель | The divisor. |
ОТБР(число, [количество_цифр])
Returns a number truncated to the number of decimal places specified.
| число | The number that you want truncated. |
| количество_цифр | The number of decimal places to truncate to (may be negative). |
Returns the value of Pi.
ПРОИЗВЕД(число1, [число2, ...])
Returns the product of a list of numbers.
| число1, ... | The numbers that you want to multiply together. |
ПРОМЕЖУТОЧНЫЕ.ИТОГИ(номер_функции, ссылка1, [ссылка2, ...])
Returns the subtotal of values in one or more ranges, excluding other subtotal figures.
| номер_функции | The subtotal function that you want. The possible values are: | ||||||||||||||||||||||
| |||||||||||||||||||||||
| ссылка1, ... | The ranges of cells that you want subtotalled. |
Converts an angle from degrees to radians.
| угол | The angle that you want to convert. |
Returns a string representing a number converted to roman numerals.
| число | The number that you want to convert. | ||||||||||||||
| форма | Specifies the compactness of the representation. The possible values are: | ||||||||||||||
| |||||||||||||||
| If this parameter is omitted it defaults to 0. |
РЯД.СУММ(x, n, m, coefficients)
Returns the value of a polynomial.
| x | The number to be raised to a power. |
| n | The power of the first term in the series. |
| m | The difference between successive powers in the series. |
| coefficients | An array or reference to cells containing the coefficients. |
СЛУЧМЕЖДУ(наименьшее, наибольшее)
Returns a random integer in the range you specify.
| наименьшее | The lower limit of the range. |
| наибольшее | The upper limit of the range. |
Returns a random number between 0 and 1.
Returns the number raised to the power.
| число | The number which you want raised to a power. |
| степень | The power to which you want to raise the number. |
Returns the sum of a list of numbers.
| число1, ... | The numbers that you want to add together. |
СУММЕСЛИ(диапазон, условие, [диапазон_суммирования])
Returns the sum of cells in a specified range that meet the specified criteria.
| диапазон | A reference to the cells you want to check. |
| условие | A string containing a comparison expression. |
| диапазон_суммирования | A range containing values to be summed where the values in the first range meet the specified criteria. If this parameter is omitted then the values in the first range are summed. |
Returns the sum of the squares of the numbers in the list.
| число1, ... | The numbers that are to be squared and then summed. |
СУММКВРАЗН(массив_x, массив_y)
Returns the sum of the squares of the differences of the numbers in the ranges.
| массив_x | The first range of numbers. |
| массив_y | The second range of numbers. |
СУММПРОИЗВ(массив1, [массив2, ...])
Returns the sum of the products of the cells in one or more ranges.
| массив1, ... | The ranges of cells where corresponding values are multiplied together and then summed. |
СУММРАЗНКВ(массив_x, массив_y)
Returns the sum of the differences of the squares of the numbers in the ranges.
| массив_x | The first range of numbers. |
| массив_y | The second range of numbers. |
СУММСУММКВ(массив_x, массив_y)
Returns the sum of the sums of the squares of the numbers in the ranges.
| массив_x | The first range of numbers. |
| массив_y | The second range of numbers. |
Returns the number of cells in a specified range that meet the specified criteria.
| диапазон | A reference to the cells you want to count. |
| условие | A string containing a comparison expression. |
Returns the factorial of a number.
| число | The number of which you want the factorial. |
Returns the number rounded down to the next integer.
| число | The number which you want rounded. |
Returns the number rounded up to the next even number.
| число | The number which you want rounded. |
ЧАСТНОЕ(numerator, denominator)
Returns the integer result of a division.
| numerator | The dividend. |
| denominator | The divisor. |
ЧИСЛКОМБ(число, выбранное_число)
Returns the number of combinations in which a number of items can be chosen from a total number.
| число | The total number of items. |
| выбранное_число | The number of items chosen. |
FРАСП(x, степени_свободы1, степени_свободы2)
Returns the F distribution probability.
| x | The value at which you want to evaluate the function. |
| степени_свободы1 | The degrees of freedom of the first set. |
| степени_свободы2 | The degrees of freedom of the second set. |
FРАСПОБР(вероятность, степени_свободы1, степени_свободы2)
Returns the value associated with the specified F distribution probability.
| вероятность | The probability for which you want the value. |
| степени_свободы1 | The degrees of freedom of the first set. |
| степени_свободы2 | The degrees of freedom of the second set. |
Returns the probability result of the z test.
| массив | An array or reference to cells containing the data against which x is to be tested. |
| x | The value to be tested. |
| сигма | The population standard deviation. If this parameter is omitted it defaults to the sample standard deviation of the data. |
БЕТАОБР(вероятность, альфа, бета, [А], [B])
Returns the value associated with the specified cumulative beta distribution probability.
| вероятность | The cumulative beta distribution probability for which you want the value. |
| альфа | The alpha value. |
| бета | The beta value. |
| А | The lower limit. If this parameter is omitted it defaults to 0. |
| B | The upper limit. If this parameter is omitted it defaults to 1. |
БЕТАРАСП(x, альфа, бета, [А], [B])
Returns the cumulative beta distribution probability.
| x | The value at which you want to evaluate the function. |
| альфа | The alpha value. |
| бета | The beta value. |
| А | The lower limit. If this parameter is omitted it defaults to 0. |
| B | The upper limit. If this parameter is omitted it defaults to 1. |
БИНОМРАСП(число_s, испытания, вероятность_s, интегральный)
Returns the binomial distribution probability.
| число_s | The number of trials that are successful. | ||||
| испытания | The total number of trials. | ||||
| вероятность_s | The probability of a single trial being successful. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ВЕЙБУЛЛ(x, альфа, бета, интегральный)
Returns the Weibull distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| альфа | The alpha value. | ||||
| бета | The beta value. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ВЕРОЯТНОСТЬ(x_диапазон, диапазон_вероятн, нижний_предел, [верхний_пред])
Returns the probability that numbers in a set are between the specified limits.
| x_диапазон | An array or reference to cells containing the numbers. |
| диапазон_вероятн | An array or reference to cells containing the probabilities associated with each number. These values must add up to 1. |
| нижний_предел | The lower limit of the test. |
| верхний_пред | The upper limit of the test. If this value is omitted it defaults to the value specified for the lower limit. |
Returns the natural logarithm of the gamma function evaluated at x.
| x | The value at which you want to evaluate the function. |
ГАММАОБР(вероятность, альфа, бета)
Returns the value associated with the specified gamma distribution probability.
| вероятность | The probability for which you want the value. |
| альфа | The alpha value. |
| бета | The beta value. |
ГАММАРАСП(x, альфа, бета, интегральный)
Returns the gamma distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| альфа | The alpha value. | ||||
| бета | The beta value. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ГИПЕРГЕОМЕТ(пример_s, размер_выборки, ген_совокупность_s, размер_ген_совокупности)
Returns the hypergeometric distribution probability.
| пример_s | The number of sample trials that are successful. |
| размер_выборки | The total number of trials in the sample. |
| ген_совокупность_s | The number of population trials that are successful. |
| размер_ген_совокупности | The total number of trials in the population. |
Returns the variance (based on a population sample) of a set of numbers.
| число1, ... | The numbers of which you want the variance. |
ДИСПА(значение1, [значение2, ...])
Returns the variance (based on a population sample) of a set of values.
| значение1, ... | The values of which you want the variance. |
Returns the variance (based on the entire population) of a set of numbers.
| число1, ... | The numbers of which you want the variance. |
ДИСПРА(значение1, [значение2, ...])
Returns the variance (based on the entire population) of a set of values.
| значение1, ... | The values of which you want the variance. |
ДОВЕРИТ(альфа, стандартное_откл, размер)
Returns the confidence interval for a population mean.
| альфа | The significance level. |
| стандартное_откл | The population standard deviation. |
| размер | The sample size. |
КВАДРОТКЛ(число1, [число2, ...])
Returns the sum of the squares of the differences of a set of numbers from their mean.
| число1, ... | The numbers of which you want the squared deviations. |
Returns the specified quartile of a set of numbers.
| массив | An array or reference to cells containing the numbers. | ||||||||||
| значение | Specifies which quartile to return. The possible values are: | ||||||||||
|
КВПИРСОН(известные_y, известные_x)
Returns the square of the Pearson correlation coefficient.
| известные_y | The first range to be compared. |
| известные_x | The second range to be compared. |
Returns the covariance of two ranges.
| массив1 | The first range to be compared. |
| массив2 | The second range to be compared. |
Returns the correlation coefficient of two ranges.
| массив1 | The first range to be compared. |
| массив2 | The second range to be compared. |
КРИТБИНОМ(испытания, вероятность_s, альфа)
Returns the value at which the cumulative binomial distribution is greater than or equal to alpha.
| испытания | The total number of trials. |
| вероятность_s | The probability of a single trial being successful. |
| альфа | The value at which you want to evaluate the function. |
ЛГРФПРИБЛ(изв_знач_y, [изв_знач_x], [константа], [стат])
Returns the coefficients for an exponential curve using multiple linear regression.
| изв_знач_y | The y values that are already known. | ||||
| изв_знач_x | One or more sets of x values corresponding to the known y values. If this parameter is omitted it defaults to an array of values from 1 to the number of known ys. | ||||
| константа | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. | |||||
| стат | Specifies whether the additional statistics are returned in the rows below the coefficients. These are: the standard error values for the coefficients, the R2 coefficient, the standard error for the Y estimate, the F statistic, the degrees of freedom, the regression sum of squares and the residual sum of squares. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
ЛИНЕЙН(изв_знач_y, [изв_знач_x], [константа], [стат])
Returns the coefficients for a straight line using multiple linear regression.
| изв_знач_y | The y values that are already known. | ||||
| изв_знач_x | One or more sets of x values corresponding to the known y values. If this parameter is omitted it defaults to an array of values from 1 to the number of known ys. | ||||
| константа | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. | |||||
| стат | Specifies whether the additional statistics are returned in the rows below the coefficients. These are: the standard error values for the coefficients, the R2 coefficient, the standard error for the Y estimate, the F statistic, the degrees of freedom, the regression sum of squares and the residual sum of squares. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
ЛОГНОРМОБР(вероятность, среднее, стандартное_откл)
Returns the value associated with the specified cumulative lognormal distribution probability.
| вероятность | The probability for which you want the value. |
| среднее | The mean of the natural logarithms of the values. |
| стандартное_откл | The standard deviation of the natural logarithms of the values. |
ЛОГНОРМРАСП(x, среднее, стандартное_откл)
Returns the cumulative lognormal distribution probability.
| x | The value at which you want to evaluate the function. |
| среднее | The mean of the natural logarithms of the values. |
| стандартное_откл | The standard deviation of the natural logarithms of the values. |
Returns the maximum of a set of numbers.
| число1, ... | The numbers of which you want the maximum. |
МАКСА(значение1, [значение2, ...])
Returns the maximum of a set of values.
| значение1, ... | The values of which you want the maximum. |
МЕДИАНА(число1, [число2, ...])
Returns the median of a set of numbers.
| число1, ... | The numbers of which you want the median. |
Returns the minimum of a set of numbers.
| число1, ... | The numbers of which you want the minimum. |
МИНА(значение1, [значение2, ...])
Returns the minimum of a set of values.
| значение1, ... | The values of which you want the minimum. |
Returns the mode of a set of numbers.
| число1, ... | The numbers of which you want the mode. |
Returns the kth largest number in a set of numbers.
| массив | An array or reference to cells containing numbers of which you want the kth largest. |
| k | The rank of the number that you want. |
Returns the kth smallest number in a set of numbers.
| массив | An array or reference to cells containing numbers of which you want the kth smallest. |
| k | The rank of the number that you want. |
НАКЛОН(изв_знач_y, изв_знач_x)
Returns the slope of a line passing through a specified set of points.
| изв_знач_y | The y values that are already known. |
| изв_знач_x | The x values that are already known. |
НОРМАЛИЗАЦИЯ(x, среднее, стандартное_откл)
Returns the standardized value of x for the specified mean and standard deviation.
| x | The value that you want to standardize. |
| среднее | The mean of the values. |
| стандартное_откл | The standard deviation of the values. |
НОРМОБР(вероятность, среднее, стандартное_откл)
Returns the value associated with the specified cumulative normal distribution probability.
| вероятность | The probability for which you want the value. |
| среднее | The mean of the values. |
| стандартное_откл | The standard deviation of the values. |
НОРМРАСП(x, среднее, стандартное_откл, интегральный)
Returns the normal distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| среднее | The mean of the values. | ||||
| стандартное_откл | The standard deviation of the values. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
Returns the value associated with the specified cumulative standard normal distribution probability.
| вероятность | The probability for which you want the value. |
Returns the cumulative standard normal distribution probability.
| z | The value at which you want to evaluate the function. |
ОТРБИНОМРАСП(число_f, число_s, вероятность_s)
Returns the negative binomial distribution probability.
| число_f | The number of trials that fail. |
| число_s | The threshold number of trials that are successful. |
| вероятность_s | The probability of a single trial being successful. |
ОТРЕЗОК(изв_знач_y, изв_знач_x)
Returns the expected value of y when x is zero for a line passing though a specified set of points.
| изв_знач_y | The y values that are already known. |
| изв_знач_x | The x values that are already known. |
ПЕРЕСТ(число, выбранное_число)
Returns the number of permutations in which a number of items can be chosen from a total number.
| число | The total number of items. |
| выбранное_число | The number of items chosen. |
Returns the kth percentile of a set of values.
| массив | An array or reference to cells containing the values. |
| k | The percentile value. |
Returns the Pearson correlation coefficient.
| массив1 | The first range to be compared. |
| массив2 | The second range to be compared. |
ПРЕДСКАЗ(x, изв_знач_y, изв_знач_x)
Returns the expected value of y for a given x value for a line passing through a specified set of points.
| x | The x value at which to evaluate the function. |
| изв_знач_y | The y values that are already known. |
| изв_знач_x | The x values that are already known. |
ПРОЦЕНТРАНГ(массив, x, [значимость])
Returns the percentile of a value in a set of values.
| массив | An array or reference to cells containing the values. |
| x | The value of which you want the percentile. |
| значимость | The number of decimal places required in the result. If this parameter is omitted it defaults to 3. |
ПУАССОН(x, среднее, интегральный)
Returns the Poisson distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| среднее | The mean of the values. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
РАНГ(число, ссылка, [порядок])
Returns the rank of a number in a set of numbers.
| число | The number of which you want the rank. | ||||
| ссылка | An array or reference to cells containing the values. | ||||
| порядок | Specifies whether the list is treated as being in ascending or descending order of value. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
РОСТ(изв_знач_y, [изв_знач_x], [нов_знач_x], [константа])
Returns the expected values of y for given x values for an exponential curve passing through a specified set of points.
| изв_знач_y | The y values that are already known. | ||||
| изв_знач_x | The x values that are already known. If this parameter is omitted it defaults to an array of values from 1 to the number of known ys. | ||||
| нов_знач_x | The new x values for which y values are required. If this parameter is omitted it defaults to the known xs. | ||||
| константа | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
Returns the skewness of a set of numbers.
| число1, ... | The numbers of which you want the skewness. |
Returns the harmonic mean of a set of numbers.
| число1, ... | The numbers of which you want the harmonic mean. |
Returns the geometric mean of a set of numbers.
| число1, ... | The numbers of which you want the geometric mean. |
Returns the average of a set of numbers.
| число1, ... | The numbers of which you want the average. |
СРЗНАЧА(значение1, [значение2, ...])
Returns the average of a set of values.
| значение1, ... | The values of which you want the average. |
Returns the average of the differences of a set of numbers from their mean.
| число1, ... | The numbers of which you want the average deviation. |
СТАНДОТКЛОН(число1, [число2, ...])
Returns the standard deviation (based on a population sample) of a set of numbers.
| число1, ... | The numbers of which you want the standard deviation. |
СТАНДОТКЛОНА(значение1, [значение2, ...])
Returns the standard deviation (based on a population sample) of a set of values.
| значение1, ... | The values of which you want the standard deviation. |
СТАНДОТКЛОНП(число1, [число2, ...])
Returns the standard deviation (based on the entire population) of a set of numbers.
| число1, ... | The numbers of which you want the standard deviation. |
СТАНДОТКЛОНПА(значение1, [значение2, ...])
Returns the standard deviation (based on the entire population) of a set of values.
| значение1, ... | The values of which you want the standard deviation. |
СТОШYX(изв_знач_y, изв_знач_x)
Returns the standard error of the y values of a line passing through a specified set of points.
| изв_знач_y | The y values that are already known. |
| изв_знач_x | The x values that are already known. |
СТЬЮДРАСП(x, степени_свободы, хвосты)
Returns the Student's T distribution probability.
| x | The value at which you want to evaluate the function. |
| степени_свободы | The degrees of freedom. |
| хвосты | Specifies the tails to include in the distribution. Should be 1 or 2. |
СТЬЮДРАСПОБР(вероятность, степени_свободы)
Returns the value associated with the specified Student's T distribution probability.
| вероятность | The probability for which you want the value. |
| степени_свободы | The degrees of freedom. |
СЧЁТ(значение1, [значение2, ...])
Returns the count of numbers in a list.
| значение1, ... | The items whose numbers are to be counted. |
СЧЁТЗ(значение1, [значение2, ...])
Returns the count of values in a list.
| значение1, ... | The items whose values are to be counted. |
ТЕНДЕНЦИЯ(изв_знач_y, [изв_знач_x], [нов_знач_x], [константа])
Returns the expected values of y for given x values for a line passing through a specified set of points.
| изв_знач_y | The y values that are already known. | ||||
| изв_знач_x | The x values that are already known. If this parameter is omitted it defaults to an array of values from 1 to the number of known ys. | ||||
| нов_знач_x | The new x values for which y values are required. If this parameter is omitted it defaults to the known xs. | ||||
| константа | Specifies whether the line must pass through the origin. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
ТТЕСТ(массив1, массив2, хвосты, тип)
Returns the probability result of the Student's T test.
| массив1 | The first range to be compared. | ||||||
| массив2 | The second range to be compared. | ||||||
| хвосты | Specifies the tails to include in the distribution. Should be 1 or 2. | ||||||
| тип | Specifies which type of test is required. The possible values are: | ||||||
|
Returns the mean of a set of numbers with the extreme values removed.
| массив | An array or reference to cells containing the numbers. |
| процент | The percentage of the numbers to exclude from the calculation. |
Returns the Fisher transformation.
| x | The value at which to evaluate the function. |
Returns the inverse Fisher transformation.
| y | The value at which to evaluate the function. |
Returns the probability result of the F test.
| массив1 | The first range to be compared. |
| массив2 | The second range to be compared. |
ХИ2ОБР(вероятность, степени_свободы)
Returns the value associated with the specified chi-squared distribution probability.
| вероятность | The probability for which you want the value. |
| степени_свободы | The number of degrees of freedom. |
Returns the chi-squared distribution probability.
| x | The value at which you want to evaluate the function. |
| степени_свободы | The number of degrees of freedom. |
ХИ2ТЕСТ(фактический_интервал, ожидаемый_интервал)
Returns the probability result of the chi-squared test.
| фактический_интервал | An array or reference to cells containing the empirical results. |
| ожидаемый_интервал | An array or reference to cells containing the theoretical results. |
ЧАСТОТА(массив_данных, двоичный_массив)
Returns the counts of items in specified numeric categories.
| массив_данных | An array or reference to a range of cells containing values to be counted. |
| двоичный_массив | An array or reference to a range of cells containing the upper limits for each category. |
ЭКСПРАСП(x, лямбда, интегральный)
Returns the exponential distribution probability.
| x | The value at which you want to evaluate the function. | ||||
| лямбда | The lambda value. | ||||
| интегральный | Specifies whether to return the cumulative probability or not. The possible values are: | ||||
|
ЭКСЦЕСС(число1, [число2, ...])
Returns the kurtosis of a set of numbers.
| число1, ... | The numbers of which you want the kurtosis. |
Returns the length of the input string.
| текст | The string of which you want the length. |
ЗАМЕНИТЬ(старый_текст, нач_ном, число_литер, новый_текст)
Returns a string which is the input string with a specified portion replaced.
| старый_текст | The string you want to convert. |
| нач_ном | The starting position of the text to be removed. |
| число_литер | The number of characters to be removed. |
| новый_текст | The text to be inserted into the string. |
Returns a number which corresponds to the value in the input string. You should not need to use this function, as values are automatically converted from text to numeric when required in formulas.
| текст | The string that you want to convert to a number. |
Returns the position in the character set of the first character in the string.
| текст | The character of which you want the character code. |
Returns a string consisting of the specified number of characters from the beginning of the input string.
| текст | The string of which you want the beginning. |
| число_литер | The number of characters to extract from the string. If this parameter is omitted it defaults to 1. |
НАЙТИ(найти_текст, внутр_текст, [нач_ном])
Returns a number corresponding to the position of one text string within another (case-sensitive).
| найти_текст | The text you want to find. |
| внутр_текст | The text to be searched. |
| нач_ном | The position at which to start searching. If this parameter is omitted it defaults to 1. |
Returns a string corresponding to the input string with any unprintable characters removed.
| текст | The text from which you want to remove unprintable characters. |
ПОВТОР(текст, число_повторений)
Returns a string which is the input string repeated a specified number of times.
| текст | The string you want to repeat. |
| число_повторений | The number of times to repeat the string. |
ПОДСТАВИТЬ(текст, стар_текст, нов_текст, [ном_вхождения])
Returns a string which is the input string with specified text replaced.
| текст | The string you want to convert. |
| стар_текст | The string to be removed from the original text. |
| нов_текст | The string to be inserted in the original text. |
| ном_вхождения | Specifies which occurrence of old_text is to be replaced. If this parameter is omitted then all occurrences are replaced. |
ПОИСК(найти_текст, внутр_текст, [нач_ном])
Returns a number corresponding to the position of one text string within another (not case-sensitive).
| найти_текст | The text you want to find. |
| внутр_текст | The text to be searched. |
| нач_ном | The position at which to start searching. If this parameter is omitted it defaults to 1. |
ПРАВСИМВ(текст, [число_литер])
Returns a string consisting of the specified number of characters from the end of the input string.
| текст | The string of which you want the end. |
| число_литер | The number of characters to extract from the string. If this parameter is omitted it defaults to 1. |
Returns a string which is the input string with all of the characters converted to upper case.
| текст | The string that you want to convert. |
Returns a string which is the input string with the first letter of each word converted to upper case and all of the other characters converted to lower case.
| текст | The string you want to convert. |
ПСТР(текст, нач_ном, число_литер)
Returns a string consisting of the specified number of characters from the specified position of the input string.
| текст | The string of which you want the extract. |
| нач_ном | The starting position of characters to extract from the string. |
| число_литер | The number of characters to extract from the string. |
Returns a string consisting of the input number rounded to the specified number of decimal places and converted to currency format.
| число | The amount that you want to format. |
| дес_цифры | The number of decimal places required. If this parameter is omitted it defaults to 2. |
Returns a string consisting of the input string with any extra spaces removed.
| текст | The string that you want to format. |
Returns the character corresponding to the specified position in the character set.
| число | The number of the character that you want. |
Returns ИСТИНА if the input strings are exactly the same, otherwise ЛОЖЬ.
| текст1 | The first string to be compared. |
| текст2 | The second string to be compared. |
Returns a string which is the input string with all of the characters converted to lower case.
| текст | The string you want to convert. |
СЦЕПИТЬ(текст1, [текст2, ...])
Returns a string consisting of the input strings concatenated together.
| текст1, ... | The strings that you want to concatenate. |
Returns a string which is the input value if it is text, otherwise an empty string.
| значение | The value you want if it is a string. |
ТЕКСТ(значение, строка_формат)
Returns a string consisting of the input number formatted using the specified format string.
| значение | The number that you want to format. |
| строка_формат | The format string to use. |
ФИКСИРОВАННЫЙ(число, [дес_цифры], [без_запятых])
Returns a string consisting of the input number rounded to the specified number of decimal places.
| число | The number that you want to format. | ||||
| дес_цифры | The number of decimal places required. If this parameter is omitted it defaults to 2. | ||||
| без_запятых | Specifies whether to suppress the thousands separator in the formatted number. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
АРГУМЕНТ([строка_имени], [номер_типа_данных], [ссылка])
Defines an argument for a custom function.
| строка_имени | The defined name that will be assigned to the argument. If this parameter is omitted then no name will be assigned. | ||||||||||||
| номер_типа_данных | The acceptable data type(s) for the argument value. It can be any combination of the following (to specify more than one value, add the numbers together): | ||||||||||||
| |||||||||||||
| If this parameter is omitted it defaults to 7. | |||||||||||||
| ссылка | The cell reference where the argument value will be stored. If this parameter is omitted then the argument value will not be stored. |
Forces the macro to end, and if it is a custom function then to return the specified value.
| значение | For custom functions, the value to be returned. |
ДЛЯ(имя_счетчика, нач_ном, кон_число, [шаг_ном])
Performs a group of instructions a specified number of times. The end of the group is indicated by a СЛЕД function.
| имя_счетчика | A defined name that will be used to store the current index. |
| нач_ном | The initial value to be assigned to the counter. |
| кон_число | The last value to be assigned to the counter. |
| шаг_ном | The value to be added to the counter each time around the loop. |
| If this parameter is omitted it defaults to 1. |
ДЛЯ.ЯЧЕЙКИ(ссылка_на_имя, [ссылка_на_область], [проп_пустые])
Performs a group of instructions for each cell in a specified area. The end of the group is indicated by a СЛЕД function.
| ссылка_на_имя | A defined name that will be used to store the current reference. | ||||
| ссылка_на_область | The range of cells to be processed. | ||||
| If this parameter is omitted it defaults to the current selection. | |||||
| проп_пустые | Whether blank cells are to be skipped. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
Specifies a logical test that conditions the execution of a block of statements.
| логическое_выражение | An expression that results in ИСТИНА or ЛОЖЬ. |
Forces the macro to wait until the date/time specified by the serial number.
| дата_как_число | The date/time when the macro is to resume. If this parameter is omitted the macro does not wait. |
Introduces the block of statements to be processed when the corresponding ЕСЛИ or ИНАЧЕ.ЕСЛИ condition is false.
ИНАЧЕ.ЕСЛИ(логическое_выражение)
Specifies another logical test that conditions a block of statements when the corresponding ЕСЛИ or ELSE.IF condition is false.
| логическое_выражение | An expression that results in ИСТИНА or ЛОЖЬ. |
Specifies the end of the block of statements conditioned by the corresponding ЕСЛИ or ИНАЧЕ.ЕСЛИ.
Forces the macro to continue with the statement at the reference.
| ссылка | The reference of the cell where macro execution is to continue. |
Specifies a logical test that conditions the execution of a block of statements multiple times. The statements between the ПОКА and СЛЕД functions will be repeated as long as the logical test returns the value ИСТИНА.
| лог_выражение | An expression that results in ИСТИНА or ЛОЖЬ. |
Ends the processing of a ДЛЯ, ДЛЯ.ЯЧЕЙКИ or ПОКА loop. The macro will continue with the statement after the СЛЕД function.
Specifies the end of the block of statements contained in a ДЛЯ, ДЛЯ.ЯЧЕЙКИ or ПОКА loop.
УСТАНОВИТЬ.ЗНАЧЕНИЕ(ссылка, значения)
Stores the specified values in the specified cells on the macro sheet. Do not use this function to try to update cells on a worksheet.
| ссылка | The cells where the values are to be stored. |
| значения | The values to be stored. |
УСТАНОВИТЬ.ИМЯ(текст_имени, [значение])
Assigns a defined name to the specified value.
| текст_имени | The defined name to use. |
| значение | The value to be associated with the name. If this parameter is omitted then the name is deleted. |
АКТИВИЗИРОВАТЬ([заголовок_окна], [номер_подокна])
Specifies the workbook, sheet and/or pane that is to be active.
| заголовок_окна | The workbook and/or sheet name. If this parameter is omitted then the active window is not changed. | ||||||||
| номер_подокна | For a split window, specifies which pane is to be active. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it then the active pane is not changed. |
Returns a reference which represents the current position of the cursor on the active worksheet.
ВВОД(текст_сообщения, [ном_типа], [назван_текст], [по_умолчанию], [x_поз], [y_поз], [ссылка_на_справку])
Displays a message in a dialog box with an area for user input and ОК and Отмена buttons. If the ОК button is pressed then the text entered by the user is returned. If the Отмена button is pressed then this function returns the value ЛОЖЬ.
| текст_сообщения | The message that you want displayed in the dialog box. | ||||||||||||||
| ном_типа | The acceptable data type(s) for the data that you want returned. It can be any combination of the following (to specify more than one value, add the numbers together): | ||||||||||||||
| |||||||||||||||
| If this parameter is omitted it defaults to 2. | |||||||||||||||
| назван_текст | The title to be used for the dialog box. If this parameter is omitted it defaults to "Ввод". | ||||||||||||||
| по_умолчанию | The text that you want to be initially displayed in the input area of the dialog box. If this parameter is omitted the input area will be blank. | ||||||||||||||
| x_поз | The initial x position on the screen where the dialog box will be displayed. If this parameter is omitted it defaults to the center of the screen. (Not currently supported). | ||||||||||||||
| y_поз | The initial y position on the screen where the dialog box will be displayed. If this parameter is omitted it defaults to the center of the screen. (Not currently supported). | ||||||||||||||
| ссылка_на_справку | The name of help topic that is to be displayed if the user presses the Help button in the dialog box. If this parameter is omitted then no Help button is displayed. (Not currently supported). |
ВПРОКРУТКА(положение, [строка_логическая])
Scrolls the worksheet vertically to the specified position.
| положение | The proportional or absolute position to scroll to. | ||||
| строка_логическая | Whether the положение parameter represents a proportional or absolute row number. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
ВСТАВИТЬ([ссылка_куда_вставлять])
Simulates the Правка Вставить menu option.
| ссылка_куда_вставлять | The cells where the copied information is to be pasted. If this parameter is omitted it defaults to the current selection on the active worksheet. |
Scrolls the worksheet vertically by the specified number of pages.
| число_окон | The number of pages to scroll. A negative number will scroll towards the top. If this parameter is omitted it defaults to 1. |
Scrolls the worksheet vertically by the specified number of rows.
| колич_строк | The number of rows to scroll. A negative number will scroll towards the top. If this parameter is omitted it defaults to 1. |
Returns a reference which represents the current selection on the active worksheet.
ВЫДЕЛИТЬ([выделенное], [активная_ячейка])
Sets the selection and cursor cell on the active worksheet.
| выделенное | The cells that are to be the selection. If this parameter is omitted the current selection is not changed. |
| активная_ячейка | The cell that is to be the cursor cell. If this parameter is omitted it defaults to the top left cell in the selection. |
ВЫДЕЛИТЬ.ДО.КОНЦА(номер_направления)
Simulates the Ctrl+arrow key combination.
| номер_направления | The direction in which to move the cursor. The possible values are: | ||||||||
|
Simulates the Ctrl+End key combination.
Returns information about the caller of the macro.
| Macro called from: | Function returns: |
| User-defined function | reference of cell containing function call |
| User-defined function in array formula | reference of array formula range |
| Attached to control or drawing object | object identifier |
| Авто_открыть macro | file name |
| Manually (control key combination) | error value #ССЫЛКА! |
ВЫРАВНИВАНИЕ([гориз_выравнивание], [сворачивать], [верт_выравнивание], [ориентация], [доб_отступ])
Simulates the Формат Ячейки dialog Выравнивание page.
| гориз_выравнивание | The horizontal alignment to be used. The possible values are: | ||||||||||||||
| |||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||
| сворачивать | Whether to wrap the text in the cells. The possible values are: | ||||||||||||||
| |||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||
| верт_выравнивание | The vertical alignment to be used. The possible values are: | ||||||||||||||
| |||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||
| ориентация | Not currently implemented. | ||||||||||||||
| доб_отступ | Not currently implemented. |
ВЫРЕЗАТЬ([из_ссылки], [ссылка_куда_вставлять])
Simulates the Правка Вырезать menu option.
| из_ссылки | The cells that are to be cut to the clipboard. If this parameter is omitted it defaults to the current selection on the active worksheet. |
| ссылка_куда_вставлять | The cells where the cut information is to be pasted. If this parameter is omitted then the cells are not pasted. |
[высота_числ], [ссылка], [стандартная_высота], [тип_число]
Simulates the Формат Строка menu options.
| высота_числ | The new height of the rows. The height is measured in points. This parameter is ignored if стандартная_высота is ИСТИНА or тип_число is specified. If this parameter is omitted the height of the specified rows is not changed. | ||||||
| ссылка | The rows whose height is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet. | ||||||
| стандартная_высота | Specifies whether the rows are to be set to the standard row height. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to ЛОЖЬ. | |||||||
| тип_число | Specifies whether the rows are to be hidden, unhidden or automatically sized. This parameter is ignored if стандартная_высота is ИСТИНА. The possible values are: | ||||||
| |||||||
| If this parameter is omitted the rows will not be hidden, unhidden or auto-sized. |
Returns the result of evaluating a formula.
| текст_формулы | The formula to be evaluated. |
Causes the current worksheet to be recalculated.
Causes all worksheets to be recalculated.
ГПРОКРУТКА(положение, [признак_столбца])
Scrolls the worksheet horizontally to the specified position.
| положение | The proportional or absolute position to scroll to. | ||||
| признак_столбца | Whether the position parameter represents a proportional or absolute column number. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
Scrolls the worksheet horizontally by the specified number of pages.
| число_окон | The number of pages to scroll. A negative number will scroll to the left. If this parameter is omitted it defaults to 1. |
Scrolls the worksheet horizontally by the specified number of columns.
| колич_столбцов | The number of columns to scroll. A negative number will scroll to the left. If this parameter is omitted it defaults to 1. |
ЗАМЕТКА([добавить_текст], [ячейка_ссылка], [старт_символ], [номер_диаграммы])
Simulates the Вставка Примечание menu option.
| добавить_текст | The text that is to be added. If this parameter is omitted it defaults to an empty string. |
| ячейка_ссылка | The cell where the comment is to be inserted. If this parameter is omitted it defaults to the active cell. |
| старт_символ | The start position in an existing comment where the new text is to be inserted. If this parameter is omitted it defaults to 1. |
| номер_диаграммы | The length of text in an existing comment that is to be replaced. If this parameter is omitted it defaults to the length of the existing text. |
Simulates the Правка Заполнение Вверх menu option.
Simulates the Правка Заполнение Влево menu option.
Simulates the Правка Заполнение Вниз menu option.
Simulates the Правка Заполнение Вправо menu option.
ЗАЩИТА.ЯЧЕЙКИ([заблокированный], [скрытый])
Simulates the Формат Ячейки dialog Защита page.
| заблокированный | Whether the cell should be locked when the sheet is protected. The possible values are: | ||||
| |||||
| If this parameter is omitted the setting is not changed. | |||||
| скрытый | Whether the cell formula should be hidden when the sheet is protected. The possible values are: | ||||
| |||||
| If this parameter is omitted the setting is not changed. |
ЗАЩИТИТЬ.ДОКУМЕНТ([содержимое], [окна], [пароль], [объекты], [сценарии])
Simulates the Формат Лист Защитить menu option.
| содержимое | Whether to protect the locked cell contents. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. | |||||
| окна | Whether to protect windows from being moved or sized (not currently implemented). The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. | |||||
| пароль | An optional case-sensitive password to protect or unprotect the document. | ||||
| объекты | Whether to protect the locked objects (not currently implemented). The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. | |||||
| сценарии | Whether to protect the scenarios (not currently implemented). The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
Returns the path of the current directory, and optionally allows you to change it.
| путь | The path to which you want to change the current directory. If this parameter is omitted the current directory is not changed. |
КОПИРОВАТЬ([из_ссылки], [ссылка_куда_вставлять])
Simulates the Правка Копировать menu option.
| из_ссылки | The cells that are to be copied to the clipboard. If this parameter is omitted it defaults to the current selection on the active worksheet. |
| ссылка_куда_вставлять | The cells where the copied information is to be pasted. If this parameter is omitted then the cells are not pasted. |
Simulates the Формат Лист Масштаб menu option.
| увеличение | The magnification option. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to ИСТИНА. |
Simulates the Правка Отменить menu option.
ПО.ЛИСТУ([текст_листа], [макрос_текст], [флаг_активации])
Specifies a macro to be run when a sheet is activated or deactivated.
| текст_листа | The name of the sheet for which the macro is to be run. If this parameter is omitted then the macro will be run for all sheets. | ||||
| макрос_текст | The defined name that refers to the macro that is to be run. If this parameter is omitted then no macro will be run. | ||||
| флаг_активации | Specifies whether the macro is to be run when the sheet is activated or deactivated. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
ПОДБОР.ПАРАМЕТРА(целевая_ячейка, целевое_значение, переменная_ячейка)
Simulates the Формат Данные Подбор параметра menu option.
| целевая_ячейка | The cell that is required to be a certain value. It must be a single cell containing a formula that returns a numeric result. |
| целевое_значение | The value that the target cell needs to reach. |
| переменная_ячейка | The cell whose value can be changed. It must be a single cell that either contains a number or is empty. |
Scrolls the active cell into view.
ПОЛУЧИТЬ.ЗАМЕТКУ([ссылка_на_ячейкку], [нач_символ], [число_литер])
Returns the text of a comment.
| ссылка_на_ячейкку | The reference of the cell containing the comment. If this parameter is omitted it defaults to the active cell. |
| нач_символ | The position of the first character to be returned. If this parameter is omitted it defaults to 1. |
| число_литер | The length of the text to be returned. If this parameter is omitted it defaults to the length of the comment. |
ПОЛУЧИТЬ.ОБЪЕКТ(ном_типа, [идр_объекта], [нач_ном], [ном_счет], [item_index])
Returns information about the specified object.
| ном_типа | The type of information to return. The possible values are: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| идр_объекта | The object identifier. If this parameter is omitted it defaults to the currently selected object on the active worksheet. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| нач_ном | The text substring start position for type_num 12. If this parameter is omitted it defaults to 1. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ном_счет | The text substring length for type_num 12. If this parameter is omitted it defaults to 255. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| item_index | This parameter is not currently used. |
Simulates the Вставка Ячейки menu option.
| сдвиг_ном | The way in which the cell insertion is to be processed. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to 2. |
ПОМЕСТИТЬ.В.РАБОЧУЮКНИГУ([ном_типа])
Simulates the Вставка Лист, Диаграмма and Макрос menu options.
| ном_типа | The type of sheet that is to be added. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to the type of the currently active sheet. |
Simulates the Правка Удалить menu option.
| сдвиг_ном | The way in which the cell deletion is to be processed. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to 2. |
ПРАВКА.ЦВЕТ(номер_цвета, [красный_значение], [зеленый_значение], [голубой_значение])
Changes the color associated with a specific color number.
| номер_цвета | A number from 1 to 56, indicating which color is to be changed. |
| красный_значение | A number from 0 to 255, specifying the intensity of the red component. If this parameter is omitted the red component is not changed. |
| зеленый_значение | A number from 0 to 255, specifying the intensity of the green component. If this parameter is omitted the green component is not changed. |
| голубой_значение | A number from 0 to 255, specifying the intensity of the blue component. If this parameter is omitted the blue component is not changed. |
ПРЕДУПРЕЖДЕНИЕ(текст_сообщения, [ном_типа], [ссылка_на_справку])
Displays a message box containing the specified text. It returns ИСТИНА if the ОК button is pressed, otherwise ЛОЖЬ.
| текст_сообщения | The text to be displayed in the message box. | ||||||
| ном_типа | The type of message box to be displayed. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 2. | |||||||
| ссылка_на_справку | A reference to a Help topic (not currently implemented). |
ПРОГРЕССИЯ([строки_или_столбцы], [номер_типа], [дата_номера], [значение_шага], [кон_знач], [направление])
Simulates the Правка Заполнение Прогрессия menu option.
| строки_или_столбцы | Indicates whether the series is in rows or columns. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults depending on the shape of the current selection. | |||||||||
| номер_типа | The way in which the series values change. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to 1. | |||||||||
| дата_номера | The way in which the date values change. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to 1. | |||||||||
| значение_шага | The number used to add to or multiply by the series value. If this parameter is omitted it defaults to 1. | ||||||||
| кон_знач | The value at which to stop filling the series. If this parameter is omitted then the entire selection is filled. | ||||||||
| направление | Indicates whether to fill the series using trend values calculated from existing data. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
РАБОЧАЯ.КНИГА.АКТИВИЗИРОВАТЬ(текст_листа)
Specifies the sheet that is to be the active worksheet.
| текст_листа | The sheet that is to be the active worksheet. |
РАБОЧАЯ.КНИГА.ИМЯ(старый_текст, новый_текст)
Simulates the Формат Лист Переименовать menu option.
| старый_текст | The sheet that is to be renamed. |
| новый_текст | The new name for the sheet. |
РАБОЧАЯ.КНИГА.ПОКАЗАТЬ.СКРЫТОЕ([текст_листа])
Simulates the Формат Лист Отобразить menu option.
| текст_листа | The name of the sheet to unhide. If this parameter is omitted it defaults to the first hidden sheet. |
Simulates the Ctrl+Page Up key combination.
РАБОЧАЯ.КНИГА.СКРЫТЬ([текст_листа], [очень_скрытое])
Simulates the Формат Лист Скрыть menu option.
| текст_листа | The name of the sheet to hide. If this parameter is omitted it defaults to the currently active sheet. | ||||
| очень_скрытое | Whether to show the name of the hidden sheet in the Unhide dialog box. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
Simulates the Ctrl+Page Down key combination.
РАБОЧАЯ.КНИГА.УДАЛИТЬ([текст_листа])
Simulates the Правка Удалить лист menu option.
| текст_листа | The sheet that is to be deleted. If this parameter is omitted it defaults to the currently active sheet. |
РАМКА([контур], [левый], [правый], [верхний], [нижний], [затенить], [цвет_контура], [левый_цвет], [правый_цвет], [верхний_цвет], [нижний_цвет])
Simulates the Формат Ячейки dialog Рамка page.
| контур | The border type to be applied to the outline of the selected cells. The possible values are: | ||||||||||||||||
| |||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| левый | The border type to be used for the left border of the selected cells. The possible values are the same as for the контур parameter. | ||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| правый | The border type to be used for the right border of the selected cells. The possible values are the same as for the контур parameter. | ||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| верхний | The border type to be used for the top border of the selected cells. The possible values are the same as for the контур parameter. | ||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| нижний | The border type to be used for the bottom border of the selected cells. The possible values are the same as for the контур parameter. | ||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| затенить | Not implemented. | ||||||||||||||||
| цвет_контура | The color to be used for the outline border. The possible values are: | ||||||||||||||||
| |||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| левый_цвет | The color to be used for the left border. The possible values are the same as for the цвет_контура parameter. | ||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| правый_цвет | The color to be used for the right border. The possible values are the same as for the цвет_контура parameter. | ||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| верхний_цвет | The color to be used for the top border. The possible values are the same as for the цвет_контура parameter. | ||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||
| нижний_цвет | The color to be used for the bottom border. The possible values are the same as for the цвет_контура parameter. | ||||||||||||||||
| If this parameter is omitted the setting is not changed. |
СВОЙСТВА.ШРИФТА([шрифт], [стиль_шрифта], [размер], [перечеркнуть], [верхний_индекс], [нижний_индекс], [контур], [затенение], [подчеркнутый], [цвет], [обычный], [фон], [нач_символ], [число_символов])
Simulates the Формат Ячейки dialog Шрифт page.
| шрифт | The name of the font to be used. | ||||||||||
| стиль_шрифта | The style to be used. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted the style is not changed. | |||||||||||
| размер | The point size to be used. If this parameter is omitted the size is not changed. | ||||||||||
| перечеркнуть | Sets the strikethrough attribute. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted the strikethrough attribute is not changed. | |||||||||||
| верхний_индекс | Not currently implemented. | ||||||||||
| нижний_индекс | Not currently implemented. | ||||||||||
| контур | Not currently implemented. | ||||||||||
| затенение | Not currently implemented. | ||||||||||
| подчеркнутый | The underline style to be used. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted the underline style is not changed. | |||||||||||
| цвет | The color to be used. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted the color is not changed. | |||||||||||
| обычный | Not currently implemented. | ||||||||||
| фон | Not currently implemented. | ||||||||||
| нач_символ | Not currently implemented. | ||||||||||
| число_символов | Not currently implemented. |
Causes the computer to beep.
| тон_число | A number from 1 to 4 indicating which type of beep is to be produced (not currently implemented - all values will produce the same tone). If this parameter is omitted it defaults to 1. |
Displays a message on the status bar.
| флаг | Whether to display or hide messages. The possible values are: | ||||
| |||||
| текст | The message to be displayed. If this parameter is omitted it defaults to an empty string. |
СОРТИРОВКА([ориентация], [ключ1], [порядок1], [ключ2], [порядок2], [ключ3], [порядок3], [верхний_колонтитул], [настройка], [регистр])
Simulates the Формат Данные Сортировка menu option.
| ориентация | Specifies whether to sort the rows or columns. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 1. | |||||||||||
| ключ1 | Specifies a reference to the first column or row to sort on. If this parameter is omitted it defaults to the first column or row in the selection. | ||||||||||
| порядок1 | Specifies whether to sort the data in ascending or descending order. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 1. | |||||||||||
| ключ2 | Specifies a reference to the second column or row to sort on. If this parameter is omitted then the second key is not used. | ||||||||||
| порядок2 | Specifies whether to sort the data in ascending or descending order. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 1. | |||||||||||
| ключ3 | Specifies a reference to the third column or row to sort on. If this parameter is omitted then the third key is not used. | ||||||||||
| порядок3 | Specifies whether to sort the data in ascending or descending order. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 1. | |||||||||||
| верхний_колонтитул | Specifies whether the selected cells include a header row or column. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 2. | |||||||||||
| настройка | Specifies whether to use a custom list for the first sort key. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 1. | |||||||||||
| регистр | Specifies whether the sort should be case-sensitive. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
Simulates the Файл Сохранить menu option.
СПЕЦИАЛЬНАЯ.ВСТАВКА([ном_вставки], [номер_операции], [пропуск_пустых], [перестановка])
Simulates the Правка Специальная вставка menu option.
| ном_вставки | The type of information to be pasted. The possible values are: | ||||||||||||
| |||||||||||||
| If this parameter is omitted it defaults to 1. | |||||||||||||
| номер_операции | The way in which the data being pasted is merged with existing data. The possible values are: | ||||||||||||
| |||||||||||||
| If this parameter is omitted it defaults to 1. | |||||||||||||
| пропуск_пустых | Whether to ignore blank cells in the data being pasted. The possible values are: | ||||||||||||
| |||||||||||||
| If this parameter is omitted it defaults to ЛОЖЬ. | |||||||||||||
| перестановка | Whether to transpose the data being pasted. The possible values are: | ||||||||||||
| |||||||||||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
Returns the values of cells in a reference. You should not need to use this function, as references are automatically converted to values where necessary when they are used in formulas.
| ссылка | The reference to the cells whose values you want. |
Returns a string containing the specified reference.
| ссылка | The reference that is to be converted to text. | ||||
| а1 | Specifies the style of the reference. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
СТАНДАРТНАЯ.ШИРИНА([стандарт_число])
Simulates the Формат Столбец Стандартная ширина menu option.
| стандарт_число | The new standard width. If this parameter is omitted then the standard width is not changed. |
Simulates the Правка Очистить menu option.
| ном_типа | The type of information to clear from the current selection on the active worksheet. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to 3. |
Returns a reference corresponding to the specified text.
| текст | The string containing the reference. | ||||
| а1 | Specifies the style of the reference. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
УЗОРЫ([АУзор], [спереди], [назад])
Simulates the Формат Ячейки dialog Узоры page.
| АУзор | The number of the pattern to be applied. The possible values are: | ||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||||||||||||||||||||||||
| спереди | The number of the foreground color to be applied. The possible values are: | ||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||
| If this parameter is omitted the setting is not changed. | |||||||||||||||||||||||||||||||||||||||
| назад | The number of the background color to be applied. The possible values are: | ||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||
| If this parameter is omitted the setting is not changed. |
Deletes a file.
| имя_файла | The name of the file to be deleted. |
Closes a file that was previously opened by the ФОТКР function.
| номер_файла | The file number that was returned by the ФОТКР function. |
Writes a string of characters to a file.
| номер_файла | The file number that was returned by the ФОТКР function. |
| текст | The text to be written. |
Writes a string of characters to a file, followed by an end of line marker.
| номер_файла | The file number that was returned by the ФОТКР function. |
| текст | The text to be written. |
ФИЛЬТР([номер_поля], [критерий1], [операция], [критерий2])
Simulates the Формат Данные Фильтр Автофильтр menu option.
| номер_поля | The filter column number whose criteria are to be changed. The columns are number from left to right, with 1 being the first filtered column. If this parameter is omitted the filter is just turned on or off. | ||||
| критерий1 | A string specifying the criteria to be used. If this parameter is omitted any filter criteria are removed from the specified column. | ||||
| операция | The combination operation when multiple criteria are used. The possible values are: | ||||
| |||||
| If this parameter is omitted the second criteria is not used. | |||||
| критерий2 | A string specifying the criteria to be used. If this parameter is omitted the second criteria is not used. |
Simulates the Формат Данные Фильтр Показать все menu option.
ФИЛЬТР.УСИЛЕННЫЙ(операция, список_ссылок, [ссылка_критерия], [копировать_ссылку], [единственность_записей])
Simulates the Формат Данные Фильтр Расширенный фильтр menu option.
| операция | Whether to filter in place or copy to another location. The possible values are: | ||||
| |||||
| список_ссылок | The location of the list to be filtered. | ||||
| ссылка_критерия | The location of any filter criteria to be used. If this parameter is omitted no criteria will be applied. | ||||
| копировать_ссылку | The destination of the copied data. This is only used when operation is 2. | ||||
| единственность_записей | Whether to select unique records only. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
Simulates the Формат Данные Форма menu option.
ФОРМАТ.ЧИСЛО(строка_форматирования)
Simulates the Формат Ячейки dialog число page.
| строка_форматирования | The number format to be used. |
ФОРМУЛА(текст_формулы, [ссылка])
Enters the specified formula in the specified reference.
| текст_формулы | The formula to be inserted. |
| ссылка | The reference where formula to be inserted. If this parameter is omitted it defaults to the cursor position on the active worksheet. |
ФОРМУЛА.ЗАМЕНИТЬ(найти_текст, заменить_текст, [см_в], [около], [активная_ячейка], [с_регистром])
Simulates the Правка Найти/Заменить menu option.
| найти_текст | The text that you want to find. | ||||
| заменить_текст | The text to replace the found text with. | ||||
| см_в | Whether to match the text against all or part of a cell. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 1. | |||||
| около | Whether to search by rows or by columns. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 1. | |||||
| активная_ячейка | Whether to replace in just the current cell or in the whole sheet. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. | |||||
| с_регистром | Whether the search is case-sensitive. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to the value last used. |
ФОРМУЛА.НАЙТИ(текст, в_число, на_число, по_число, [каталог_число], [с_регистром])
Simulates the Правка Найти menu option.
| текст | The text that you want to find. | ||||||
| в_число | Where you want to look for the text. The possible values are: | ||||||
| |||||||
| на_число | Whether to match this text against all or part of a cell. The possible values are: | ||||||
| |||||||
| по_число | Whether to search by rows or by columns. The possible values are: | ||||||
| |||||||
| каталог_число | Whether to search for the next or previous match. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 1. | |||||||
| с_регистром | Whether the search is case-sensitive. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
Finds the previous cell based on the current criteria.
Finds the next cell based on the current criteria.
ФОРМУЛА.ПЕРЕЙТИ([ссылка], [угол])
Simulates the Правка Перейти menu option.
| ссылка | The cells that are to be selected. If the sheet name is omitted then it defaults to the currently active sheet. If this parameter is omitted it defaults to the sheet and cells that were selected before the last goto command. | ||||
| угол | Specifies whether the top-left corner of the selection is to be placed in the top-left corner of the window. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
ФОТКР(имя_файла, [номер_доступа])
Opens a file for reading or writing. The return value is a file number that can be passed as a parameter to the ФЧИТ, ФЧИТКС, ФЗАП, ФЗАПКС, ФПОЗ, ФРАЗМЕР, and ФЗАКР functions.
| имя_файла | The name of the file to open. | ||||||
| номер_доступа | The access required to the file. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 1. |
ФПОЗ(номер_файла, [тип_позиции])
Returns the current read/write position in a file, and optionally allows you to change it.
| номер_файла | The file number that was returned by the ФОТКР function. |
| тип_позиции | The location where the next read or write will occur. |
| If this parameter is omitted the current position is not changed. |
Returns a size of a file.
| номер_файла | The file number that was returned by the ФОТКР function. |
ФЧИТ(номер_файла, число_литер)
Returns a string of characters from a file.
| номер_файла | The file number that was returned by the ФОТКР function. |
| число_литер | The number of characters to read. |
Returns a string of characters from a file, up to the next end of line marker.
| номер_файла | The file number that was returned by the ФОТКР function. |
Copies the color palette from another file.
| имя_файла | The name of the file from which to copy the palette. The file must already be open. If this parameter is an empty string then the colors are reset to the default values. |
ШИРИНА.СТОЛБЦА([ширина_число], [ссылка], [стандартный], [тип_число], [стандарт_число])
Simulates the Формат Столбец menu options.
| ширина_число | The new width of the columns. The width is measured in characters. This parameter is ignored if стандартный is ИСТИНА or type_num is specified. If this parameter is omitted the width of the specified columns is not changed. | ||||||
| ссылка | The columns whose width is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet. | ||||||
| стандартный | Specifies whether the columns are to be set to the standard column width. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to ЛОЖЬ. | |||||||
| тип_число | Specifies whether the columns are to be hidden, unhidden or automatically sized. This parameter is ignored if стандартный is ИСТИНА. The possible values are: | ||||||
| |||||||
| If this parameter is omitted the columns will not be hidden, unhidden or auto-sized. | |||||||
| стандарт_число | Specifies the value to be used for the standard width. The width is measured in characters. If this parameter is omitted the standard width is not changed. |
ВЫЗВАТЬ(имя_модуля, процедура, тип, [аргумент1, ...])
Returns a value from an external function.
| имя_модуля | The name of the DLL that contains the function. | ||||||||||||||||||||||||||||||||||
| процедура | The name of the function. | ||||||||||||||||||||||||||||||||||
| тип | A string specifying the result type and the argument types. Each type is represented by a single character. The possible character values are: | ||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||
| аргумент1, ... | The arguments to pass to the function. |
To add a chart, use the Вставка Диаграмма menu option to add a new chart sheet. Then use the Формат Диаграмма menu option to display the dialog box that contains the following formatting options:
ТипThe program currently supports the following chart types:
| Гистограмма | Displays vertical columns whose heights correspond to the data values. |
| Линейчатая диаграмма | Displays horizontal bars whose lengths correspond to the data values. |
| График | Displays a line through points whose vertical positions correspond to the data values, the horizontal positions are evenly spaced. |
| Круговая диаграмма | Displays a circle divided up into regions whose relative sizes correspond to the data values. |
| Кольцевая | Like the Круговая chart but displays one or more series. |
| Точечная диаграмма | Displays a line through points whose x and y coordinates are given by the data values. |
| Диаграмма с областями | Like the line chart, but the area below the line is filled in, and the series values are stacked. |
| Лепестковая | Displays a line through points whose distances from a central point correspond to the data values. |
This allows you to specify the data values to be used for each series. To add a new series, press the Создать... button. To change an existing series, select it in the list box and then press the Правка... button. To remove an existing series, select it in the list box and press the Удалить button.
Note that for Круговая диаграмма charts, only the first series will be displayed.
When entering or changing a series, you are prompted for the following information:
| Данные | Имя | An optional name that is used to identify the series in the list box. It defaults to 'Series1', etc. |
| Значения Y | A reference to the cells that contain the data to be charted. You can specify more than one reference, separating them with commas, but they must all be from the same sheet. Alternatively you can specify this as an array of values. | |
| Метки по X | For Гистограмма, Линейчатая диаграмма, Круговая диаграмма, График and Диаграмма с областями charts, you can specify a reference or array of values that will be used to label the categories. As there is only one set of labels, this must be the same for all the series on one chart. For Точечная диаграмма charts, this item is labelled Значения X and you must enter a reference or array of values to be used as the x co-ordinates of the line. | |
| Узоры | Тип линии | Allows you to choose a solid, dashed or dotted line. |
| Цвет линии | Allows you to specify the color of the line. | |
| Маркер | For График, Точечная диаграмма and Лепестковая charts, allows you to choose a marker for the data points. | |
| Цвет маркер | For График, Точечная диаграмма and Лепестковая charts, allows you to choose the foreground and background colors for the marker. | |
| Цвет фона | For Гистограмма, Линейчатая диаграмма, Круговая диаграмма, Кольцевая and Диаграмма с областями charts, allows you to specify the colour that will be used to fill the interior. | |
| Подписи | Тип подписи | Allows you to display the x or y values next to the data points, and for Круговая диаграмма and Кольцевая charts the percentages. |
This allows you to specify the titles that will be used to label the chart itself and the x and y axes. Note that axis titles do not apply to Круговая диаграмма charts.
This allows you to specify the formatting of the x and y axes. The actual options that are available will depend on the currently selected chart type.
| Ось | Specifies whether the axis line will be drawn. |
| Сетка: | Specifies whether the guidelines will be drawn. |
| Деления | Specifies whether the axis tick marks will be drawn. |
| Значения | Specifies whether the axis values will be displayed. |
| Логарифмическая | Specifies whether a linear or logarithmic scale is required. |
| Минимум | Specifies the minimum value to be used on the scale. |
| Максимум | Specifies the maximum value to be used on the scale. |
| Шаг | Specifies the interval between the values on the scale. |
This allows you to specify the whether and where to display the names that identify each series with its line and/or area color. For Pie charts, the information displayed will be the category names (from the 'X labels' entry in the series formatting dialog box), for other chart types it will be the Series names from the chart series list box.
Macros can be used to create user-defined functions to use in your spreadsheets, and user-defined commands to automate tasks.
User-defined functions
Macros are useful for user-defined functions in 2 situations:
1. You may have a complex function, which is composed of many nested functions, which is used in many places on your worksheet. A user-defined function would save you a lot of typing by specifying the actual calculation in only one place.
2. You may need to use an iterative or recursive calculation that has to be performed a certain number of times before a result is found.
These are the steps for entering a user defined function:
1. Use the Вставка Макрос menu option to insert a macro sheet in the workbook. Macros must be stored on macro sheets. You can have many macros on a single macro sheet.
2. Enter the macro function statements. A user-defined function macro will usually begin with one or more АРГУМЕНТ functions to receive the parameters, and it must end with a ВОЗВРАТ function.
This example calculates the approximate integral of the function sin(x) between a lower and upper limit using the trapezium rule and dividing the area into 100 slices:
A |
B |
C |
D |
|
| 1 | Integral: | =АРГУМЕНТ(,1,D1) | lower: | |
| 2 | =АРГУМЕНТ(,1,D2) | upper: | ||
| 3 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D3,0) | sum: | ||
| 4 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D4,SIN(D1)) | y0: | ||
| 5 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D5,SIN(D2)) | yn: | ||
| 6 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D6,1) | i: | ||
| 7 | =ПОКА(D6<D7) | steps: | 100 | |
| 8 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D8,D1+(D2-D1)*D6/D7) | x: | ||
| 9 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D3,D3+SIN(D8)) | |||
| 10 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D6,D6+1) | |||
| 11 | =СЛЕД() | |||
| 12 | =ВОЗВРАТ((D2-D1)/D7/2*(D4+D5+2*D3)) |
3. Use the Вставка Имя Присвоить menu option to add a name for the macro. For the example above, you could define a name called 'integral', which refers to cell: Macro1!$B$1. Note that the macro name in cell A1 is for our reference only, it is not used by the program.
4. Then on your worksheet (or even in another macro), use the defined name like an ordinary worksheet function name.
For the example above, if you enter 0 in cell A1 on your worksheet, and =ПИ() in cell A2 on your worksheet, and =integral(A1,A2) in cell A3, then cell A3 will display 1.9998355 (higher accuracy could be obtained with a larger number of steps but the calculation would take correspondingly longer).
Here is an example that uses recursion. Because macro sheets do not directly support recursion, I have implemented a simple stack to store the values at each level by concatenating them together in a string.
This function displays a number as text:
A |
B |
C |
D |
E |
|
| 1 | Say number: | =АРГУМЕНТ(,1,D1) | input: | ||
| 2 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,"") | output: | |||
| 3 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D1,ЦЕЛОЕ(D1)) | temp: | |||
| 4 | =ЕСЛИ(D1<=0,ВОЗВРАТ(D2)) | ||||
| 5 | =ЕСЛИ(D1>=1000000) | ||||
| 6 | stack input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E1,D1&"|"&E1) | |||
| 7 | stack output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E2,D2&"|"&E2) | |||
| 8 | get millions | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D3,saynumber(D1/1000000)) | |||
| 9 | unstack output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,ЛЕВСИМВ(E2,НАЙТИ("|",E2)-1)) | |||
| 10 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E2,ПРАВСИМВ(E2,ДЛСТР(E2)-НАЙТИ("|",E2))) | ||||
| 11 | unstack input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D1,ЛЕВСИМВ(E1,НАЙТИ("|",E1)-1)) | |||
| 12 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E1,ПРАВСИМВ(E1,ДЛСТР(E1)-НАЙТИ("|",E1))) | ||||
| 13 | update output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&D3&" million") | |||
| 14 | update input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D1,ОСТАТ(D1,1000000)) | |||
| 15 | check if finished | =ЕСЛИ(D1=0,ВОЗВРАТ(D2)) | |||
| 16 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&ЕСЛИ(D1<100," and "," ")) | ||||
| 17 | =КОН.ЕСЛИ() | ||||
| 18 | =ЕСЛИ(D1>=1000) | ||||
| 19 | stack input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E1,D1&"|"&E1) | |||
| 20 | stack output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E2,D2&"|"&E2) | |||
| 21 | get thousands | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D3,saynumber(D1/1000)) | |||
| 22 | unstack output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,ЛЕВСИМВ(E2,НАЙТИ("|",E2)-1)) | |||
| 23 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E2,ПРАВСИМВ(E2,ДЛСТР(E2)-НАЙТИ("|",E2))) | ||||
| 24 | unstack input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D1,ЛЕВСИМВ(E1,НАЙТИ("|",E1)-1)) | |||
| 25 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E1,ПРАВСИМВ(E1,ДЛСТР(E1)-НАЙТИ("|",E1))) | ||||
| 26 | update output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&D3&" thousand") | |||
| 27 | update input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D1,ОСТАТ(D1,1000)) | |||
| 28 | check if finished | =ЕСЛИ(D1=0,ВОЗВРАТ(D2)) | |||
| 29 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&ЕСЛИ(D1<100," and "," ")) | ||||
| 30 | =КОН.ЕСЛИ() | ||||
| 31 | =ЕСЛИ(D1>=100) | ||||
| 32 | stack input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E1,D1&"|"&E1) | |||
| 33 | stack output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E2,D2&"|"&E2) | |||
| 34 | get hundreds | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D3,saynumber(D1/100)) | |||
| 35 | unstack output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,ЛЕВСИМВ(E2,НАЙТИ("|",E2)-1)) | |||
| 36 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E2,ПРАВСИМВ(E2,ДЛСТР(E2)-НАЙТИ("|",E2))) | ||||
| 37 | unstack input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D1,ЛЕВСИМВ(E1,НАЙТИ("|",E1)-1)) | |||
| 38 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(E1,ПРАВСИМВ(E1,ДЛСТР(E1)-НАЙТИ("|",E1))) | ||||
| 39 | update output | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&D3&" hundred") | |||
| 40 | update input | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D1,ОСТАТ(D1,100)) | |||
| 41 | check if finished | =ЕСЛИ(D1=0,ВОЗВРАТ(D2)) | |||
| 42 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&" and ") | ||||
| 43 | =КОН.ЕСЛИ() | ||||
| 44 | =ЕСЛИ(D1>=20) | ||||
| 45 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&ВЫБОР(ЦЕЛОЕ(D1/10)-1, "twenty", "thirty", "forty", "fifty", "sixty", "seventy", "eighty", "ninety")) | ||||
| 46 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D1,ОСТАТ(D1,10)) | ||||
| 47 | =ЕСЛИ(D1=0,ВОЗВРАТ(D2)) | ||||
| 48 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&" ") | ||||
| 49 | =КОН.ЕСЛИ() | ||||
| 50 | =УСТАНОВИТЬ.ЗНАЧЕНИЕ(D2,D2&ВЫБОР(D1, "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen")) | ||||
| 51 | =ВОЗВРАТ(D2) |
If we create a name ('SayNumber') for this function (Macro1!$B$1), we can enter 1234567890 in cell A1 on our worksheet, and =saynumber(A1) in cell A2 on our worksheet, and cell A2 will display:
one thousand two hundred and thirty four million five hundred and sixty seven thousand eight hundred and ninety
User-defined commands
Here is a command macro example.
This macro moves to the beginning of row 5 on the current sheet, inserts a new row, puts the current date into column A, formats it, and moves to column B ready for entry.
A |
B |
|
| 1 | NewEntry: | =ВЫДЕЛИТЬ(!$A$5) |
| 2 | =ПОМЕСТИТЬ(3) | |
| 3 | =ФОРМУЛА(СЕГОДНЯ()) | |
| 4 | =ФОРМАТ.ЧИСЛО("dd/mm/yy") | |
| 5 | =ВЫДЕЛИТЬ(!$B$5) | |
| 6 | =ВОЗВРАТ() |
We create a name for this macro, e.g. "NewEntry", pointing to the reference "Macro1!$B$1", and assign control key "t" to it.
Then on our main sheet, we can press Ctrl+t and the macro will be run. Note that the macro name in cell A1 is for our reference only, it is not used by the program.
Note that the following control keys are reserved for program operation, and should not be assigned to your command macros:
| 1 | Формат Ячейки | |
| c | Правка Копировать | |
| d | Правка Заполнение Вниз | |
| e | enter edit mode | |
| f | Правка Найти | |
| g | Правка Перейти | |
| h | Правка Заменить | |
| n | Файл Создать | |
| o | Файл Открыть | |
| p | Файл Печать | |
| r | Правка Заполнение Вправо | |
| s | Файл Сохранить | |
| v | Правка Вставить | |
| x | Правка Вырезать | |
| z | Правка Отменить | |
| ; | insert date | |
| : | insert time |
Other control keys may be reserved in future versions of the program.
You can add controls and drawing objects to a worksheet by using the Вставка Элемент управления and Вставка Графический объект menu options. After selecting the menu option, drag the pointer across the worksheet to define the area that the control will occupy. A dialog box will then be displayed that allows you to specify the attributes of the object.
To edit a control or drawing object, press the Ctrl key (on the keyboard) and then click on the object. This will select the object. Then you can use the Правка Удалить menu option or the Формат Элемент управления or Формат Графический объект menu option, or you can drag the control to a different position or you can change the shape or size by dragging the border of the object. To deselect a selected object, press the Ctrl key and click on the object again, or select a different object, or click elsewhere on the worksheet. You can also use Tab or Shift+Tab to select the next or previous object.
The following control object types are supported:
| Метка | A text label. |
| Окно группы | A rectangle with an optional heading. Useful for grouping separate sets of option buttons together. |
| Кнопка | A button that can be pressed. Useful for activating a macro. |
| Флажок | A box that can be ticked or unticked. It can return a value of ИСТИНА or ЛОЖЬ to a linked cell to indicate its state. |
| Перекл | Usually one of a group of buttons that selects one of several items. Only one of the buttons in a group can be pressed at any one time. Use a group box object to define a button group. The group of buttons can return a value to a linked cell indicating the number of the button in the group that is currently pressed. |
| Окно списка | Displays a list of items from a range in the spreadsheet. It can return the number of the selected item to a linked cell. |
| Раскр список | Displays one of a list of items from a range in the spreadsheet. It can return the number of the selected item to a linked cell. |
| Полоса прокр | A horizontal or vertical scroll bar. The orientation is determined by the shape of the rectangle when the control is first inserted. It can return the value of the current position to a linked cell. |
| Рег счетчика | A vertical spin control. It can return the current value to a linked cell. |
The following drawing object types are supported:
| Линия | A line or arrow. |
| Прямоуг | A rectangle that can be filled. |
| Овал | An oval that can be filled. |
| Подпись | A rectangle that can contain text. |
All of the objects can have a macro attached that will be run when the object is clicked on.