#### kittymongo

##### New Member

- Joined
- Feb 6, 2018

- Messages
- 13

one report has to pay accurately which is between 95%-102% (we count these as accurate). another report has to pay the same way (these 2 never match since they pull from different sources). I need a formula to show if these 2 calculate within the same data range. i have a formula in there but it is just stating if the 2 reports match per line but i am getting false matches since it is matching everything out of range as well.

report 1

cell a1 = 30% accurate

cell a2 = 98% accurate

cell a3 = 100% accurate

cell a4 = 94% accurate

cell a5 = 99% accurate

report 2

cell a1 = 30% accurate

cell a2 = 100% accurate

cell a3 = 100% accurate

cell a4 = 22% accurate

cell a5 = 91% accurate

what sort of formula can be used to show both reports are within the accurate threshold range by line?

i hope this makes sense. if not, let me know and i will try to clarify more.

Thank you so much!