Data falls in a range +/-1

[Guest]

I have the following columns:

Date Pcs Prod Pot Pcs Prod Match?
10/19 637 637.45
10/20 108 107.97
10/21 236 117.81

What I would like to do since it will be rare that "Pcs Prod" and "Pot Pcs
Prod" will be equal I need to add in a range of like +/- 1:
If Pcs Prod is +/-1 to Pot Pcs Prod then return the value "Match" else "No
Match".

If someone can help me with this if its possible please let me know.

Thanks!! Stacey

 

[vezerid]

Stacey,
use the following in D2:
=IF(AND(B2>=C2-1, B2<=C2+1), "Match", "No Match")

HTH
Kostis Vezerides

 

[Guest]

Worked perfect!
Thank you!!

 

[Bernard Liengme]

=IF(ABS(B2-C2)<=1,"match","no match")
best wishes