Help Centre › Building 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:
- Navigate to the process where you would like to add the EXCEL Enter a formula function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Enter a formula option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Cell | No | Text | – | Cell reference to enter the formula in. |
| Formula | Yes | Text | – | The Excel formula expression (e.g. =SUM(A1:A10)). |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| Invalid formula | The 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.