Set formula

Estimated reading: 2 minutes 282 views

Set formula activity is used for replacing formulas in a specified cell or range in an Excel file. If there is no formula in the cell, it cannot be used for new formula assignment.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Range	The range of cells to be received is given.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Formula	Excel formula is written without ‘=’ at the beginning.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Range as shown in the example.

A1:C5

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

You can use the Formula as shown in the example.

SUM(A1:B1)

Set formula

Recently Viewed articles

Set formula

CONTENTS