Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to compare numbers but allowing a tolerance in Excel?
In this article we will learn how to compare two number having nearby values to each other with a specified tolerance value. However using the basic formula as =A1=B1 we can directly compare the values for the exact match but sometimes we need to compare the value upto a tolerance values. For this, follow the below mentioned formula and steps.
Comparing Two Numbers having a Specified Tolerance Value
Step 1 − We have taken the following sample data for comparison.
Step 2 − Enter the formula in C2 cell as mentioned below. This formula will return True for those values where tolerance is equals to 5 or False when tolerance value is greater than 5 or less than 5.
=AND(A2<=B2+5,A2>=B2-5)
Step 3 − Now, drag the formula till the last row of data and the final output will be as following.
Formula Syntax Description
Argument |
Description |
|---|---|
AND(logical_1, logical_2, logical_3) |
AND function returns True if all the conditions are true in logic and returns False if any of the conditions is false. |
Conclusion
Hence using the above formula, adjacent numbers as well as numbers of different cells can be compared with a tolerance value. However, one more formula can also be used for the same activity i.e. =ABS(A2-B2) <=”ToleranceValue”. This will also work in the same way as mentioned above.
543 Views
