Help Centre › Functions & Formulas
This article describes the formula errors you may encounter when using formulas in the RPA.
Note: These errors come from process and bot formulas. Wiki calculated fields are a separate system with their own messages – for those, see Calculated Fields in Wikis.
Formula errors
When you use a formula, you may see an error value instead of the result you expect. The following table lists the error values that can occur in a formula.
| Error value | Description |
| #DIV/0! | You tried to divide by zero (0). |
| #NAME? | The formula contains unrecognized text. This can happen if you misspell a function name or if you use a name that is not defined in the RPA. |
| #N/A | The formula cannot find a value it needs to complete the calculation. This can happen if you use a function that requires a lookup value and that value is not found. |
| #NUM! | The formula contains invalid numeric values, such as trying to calculate the square root of a negative number or using an argument that is not valid for the function. |
| #REF! | The formula refers to a cell that is not valid, such as when a cell has been deleted or moved. |
| #VALUE! | The formula contains the wrong type of argument or operand, such as trying to perform arithmetic on text values. |