Set cell formula action

The Set cell formula action 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

  • Use the Set formula for to select one of the following options to specify the cell in which to set the formula:
    • Active cell
    • Specific cell

    If you have selected the Specific cell option, specify the address of the cell in the field.

  • in the Enter formula for specific cell field, enter the formula that you want to apply.
  • Use the Session name to select one of the following tabs for providing the session name:
    • Session name

      Enter the name of the session used to open the workbook with the Open action.

    • Variable

      Is the Excel advanced session from Set session variable action or from parent automation.