EXCEL Enter a formula function

The EXCEL Enter a formula function in RPA.

Help CentreBuilding Processes

This article describes the RPA Excel functionality to enter a formula.

For a full list of available functions, please read EXCEL functions.


Description

The EXCEL Enter a formula function allows you to enter a formula.


Setting it up

To use the EXCEL Enter a formula function, follow these instructions:

{{popups:rpas/add:action=excel-formula}}

Once on a process map:

  1. Navigate to the process where you would like to add the EXCEL Enter a formula function
  2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
  3. On the menu that appears, click on the “+ Activity” item
  4. From here you can select the EXCEL Enter a formula option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
File pathYesTextFull path to the Excel file.
CellNoTextCell reference to enter the formula in.
FormulaYesTextThe Excel formula expression (e.g. =SUM(A1:A10)).

Output variables

This action does not produce any output variables.


Errors

ErrorDescription
Invalid formulaThe formula syntax is incorrect.

Tips

  • Do not include the = sign if it is already part of your formula text.
  • Use cell references with variables for dynamic formulas.

Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.