Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The TOLERANCE function is used to calculate the tolerance of a value based on a specified percentage. This is useful in scenarios where you need to determine acceptable ranges for measurements or values.
Syntax
TOLERANCE(value, percentage)
The TOLERANCE function syntax has the following arguments:
- value: Required. The base value for which you want to calculate the tolerance.
- percentage: Required. The percentage of the base value that defines the tolerance range.
Example
| Formula | Description | Result |
| =TOLERANCE(100, 10) | Calculates the tolerance for 100 with a 10% margin. | 90 to 110 |
Errors
For a full list of formula errors, please read Formula errors.