Action group: Excel
Executes a formula in the selected cell.
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
Parameters | ||||
| Context | Action context for working with an Excel document | Excel instance | Excel context | Yes |
Column of cell | The column of the cell into which the result of the formula calculation will be written. | String | No | |
Column index | The column index of the cell where the result of the formula calculation will be written. | Numeric | No | |
Row of the cell | Cell row in which the result of the formula calculation will be written. | Numeric | Yes | |
Formula | The formula that will be used to perform the calculation in the cell. The formula starts with the "=" symbol. | String | Yes | |
Local language | If True, formula names will be given in local language, otherwise - in English. | Boolean | true | No |
Register | If the parameter value is "True", the formula bar remains unchanged. If "False", then all letters in the formula become capitalized. The default is "False". | Boolean | true | No |
By default, formulas in English are used.
Check out the feature names on the official website: https://support.office.com/en-gb/article/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb
To use the local (in our case Russian) language you should make a mark in the "Local language" field.
There is an Excel document in which values are written. It is required to write to cell C3 the result calculated by the formula =5+5*2+C1
Use the actions "Open", "Apply formula to cell", "Save".
The program robot completed successfully.
The calculated value is written in cell C3.
