Is Cell D3 within 10% of B3 True or false?
Usind AND function
=IF((AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)=-10))),TRUE,FALSE)
Rachad
"Mark B" wrote in message
...
I have two Columns of Data,
I want to know if the Data in column D is within 10% + or - of the data in
column B
e.g Is Cell D3 within 10% of B3 True or false?
Should be simple but I can't figure it out.
|