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:
We have taken an example, as you can observe in the image above, we have mentioned the actual, expected as well as tolerance data.
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.
the ABS Formula requires numbers.
So, here’s what we will do:
We will select the Actual data first, then:
We will put up a “minus” sign and then we will select the expected value.
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 <=
Then we will select the tolerance value.
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.
Then we will write “Not Agree” in the case of “value if false”.
By this, our total formula becomes:
=IF(ABS(B3-C3) <= D3, “Agree”, “Not Agree”)
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.
Here, we go.
It’s easy, isn’t it?