Hello,
I am having a difficulty creating the correct formula for the following scenario:
10.02% lets say it is in cell A1
11.49% cell A2
13.03% cell A3
I need to compare all three percentages and their differences can not exceed +/- 2.00%. Can anyone provide the correct formula to use? I am using the following:
=IF(OR((A1-A2)2%,(A1-A3)>2%, (A2-A3)>2%),"Check","OK +/-2")
Bookmarks