Calc TOLERANCE function

The TOLERANCE function is used to calculate the tolerance of a value based on a specified percentage.

Help CentreFunctions & 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

FormulaDescriptionResult
=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.


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.