Hello,
I would like to make a formula to compare two tables on the same numbers.
I made this formula =IF(E122=BE122;"Match";"").
So if E122=0.7 and BE=0.8 and it will not say match. Because it's not the exact the same.
So i would like to have a formula which matches also when it's 0.1 bigger and 0.1 smaller then the numbers which you compare it to.
=IF( AND( E122<=BE122*1.01, E122>=BE122*0.9) ;"Match";"")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Use:
=if(abs(e122-be122)<=0.1, "match","")
of course use semicolons if it is your local setting for separators.
Best Regards,
Kaper
@etaf: multiplication could be good for relative difference of 1% or 10% (1.1 and 0.9 or 1.01 and 0.99) but the idea was to focus on absolute difference of 0.1.
Thanks for the clarification
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks