Forum Discussion

adydent67's avatar
adydent67
Copper Contributor
Oct 10, 2019

Formula Required: Outside of a range (plus or minus)

I had this formula =IF(S3=R3,"Good",IF(ABS(S3-R3)<=20%,"Under","Over")) But I want to check the values are within an allowable range. So it's whether I can combine something like this to a single...
excel
Formulas and Functions
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Oct 10, 2019
This should work =IF(AND(A1-B1<0.2;A1-B1>-0.2);"GOOD";IF(A1-B1>=0.2;"OVER";"UNDER"))