Set cell formula action

The Set cell formula action in the Excel advanced package enables you to set a formula in the active cell or a specific cell in a Microsoft Excel spreadsheet or a CSV file.

To generate a random number, use the Number > Random action. See Random action.

Settings

  • Select the Set formula for active cell or Set formula for specified cell option to specify the cell in which to set the formula. If you have selected the Set formula for specified cell option, specify the address of the cell in the field.
  • Enter the formula to set in the Enter formula for specific cell field.
  • Enter the name of the session used to open the workbook with the Open action.