Man illustrationFlower illustration

Docy

Set formula

Estimated reading: 1 minute 90 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 nameThe name of the Excel file that was opened or created before is selected.
RangeExcel sheet range from which to fetch data.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
FormulaExcel formula 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

A1:C5

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

Sheet1

You can use the Formula as shown in the example.

SUM(A1:B1)
CONTENTS