In this space, you will get to analyze your data if the given value is within tolerance value or not.

At this point, you may be wondering what does it mean, right? 😅

In business, there’s always two important factors in the valuation of goals i.e. Expected performance and actual performance of the particular task. There also comes a tolerance level in which business can take to themselves.

Therefore, to analyze the performance or task or any number we will deduct

Actual – Expected => Number if it falls between your fixed tolerance value.

Exciting isn’t it? 😋

👉Previously: How to join First and Last name quickly in excel?

Value is within tolerance with IF Formula

To check whether the value is within the tolerance or not, here’s what we do:

value is within tolerance

We have taken an example, as you can observe in the image above, we have mentioned the actual, expected as well as tolerance data.

value is within tolerance

Now, the first thing that we will do is to use the IF Function i.e. =IF(

The following function requires logical test, value if true, value if false.

So, in the case of logical test, we will use ABS Function.

value is within tolerance

the ABS Formula requires numbers.

So, here’s what we will do:

value is within tolerance

We will select the Actual data first, then:

value is within tolerance

We will put up a “minus” sign and then we will select the expected value.

value is within tolerance

Then we will close the bracket of the ABS function, but as our logical test is not yet over, so we will put the following <=

value is within tolerance

Then we will select the tolerance value.

value is within tolerance

After the same, we will put a coma and move to the point of “value if true”, so let’s say we want our result to be Agree if the value is true, so we will write Agree in quotation marks.

value is within tolerance

Then we will write “Not Agree” in the case of “value if false”.

value is within tolerance

By this, our total formula becomes:

=IF(ABS(B3-C3) <= D3, “Agree”, “Not Agree”)

value is within tolerance

And then we will press “enter”. 

The answer came out as “Agree”. This means that the value is within the tolerance.

Now, the next thing that we will do is go to the bottom right corner of the cell we just worked upon, and we will drag it down to make it a fast process for the rest of the data entries.

value is within tolerance

Here, we go.

value is within tolerance

It’s easy, isn’t it?