Apply formula to cell Version 10 (Net)

Action group: Excel 

Description

Executes a formula in the selected cell.

Action icon

Settings of parameters

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

Special conditions of use

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.

Example of use 

Task

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

Solution

Use the actions "Open", "Apply formula to cell", "Save". 

Implementation

  1. Assemble a robot scheme consisting of actions:
  2. Customize the parameters of the "Open" action:
  3. Customize the parameters of the "Apply formula to cell" action:
  4. Customize the "Save" action parameter :
  5. Launch the robot using the "Start" button on the top panel. 

Result

The program robot completed successfully.

The calculated value is written in cell C3. 

  • Нет меток