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.
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.