Compare values with tolerance

[alombia]

Hi,

I have the following formula to compare tow values: =IF(BO4="","",IF(BO4<$BL4,"Poor",IF(BO4=$BL4,"Good",IF(BO4>$BL4,"Very Good"))))
As an example, BO4 is 1.5 and BL4 is 2.

However, I would like to compare the two values but with a tolerance of 0.5. In others, If BO4 is is with 0.5 of BL4, then 'Good'; less than that is 'Poor' and above that is "Very Good".

Your help is very much appreciated.
Thanks.

 

[alombia]

I have been trying to play around with the formula but it seems you cannot reference cells in place of the values

 

[admiral100]

Try this:-

=LOOKUP(BL4-BO4,$BI$1:$BK$1,{"Very Good","Good","Poor"})

Where BI1:BK1 contain the values -15 , -0.5 , 0.51 respectively.

 

[alombia]

Try this:-

=LOOKUP(BL4-BO4,$BI$1:$BK$1,{"Very Good","Good","Poor"})

Where BI1:BK1 contain the values -15 , -0.5 , 0.51 respectively.

You are amazing! Its perfectly

Suppose if i want the tolerance to be 1, would the values be: -15, -1, 1.01

 

[admiral100]

Exactly

 

[alombia]

Exactly

Thanks again. Happy new year mate.