Data falls in a range +/-1

S

SMac

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
 
V

vezerid

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

HTH
Kostis Vezerides
 
Top