Data falls in a range +/-1
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
|