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

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

HTH
Kostis Vezerides

Worked perfect!
Thank you!!

"vezerid" wrote:

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

HTH
Kostis Vezerides

=IF(ABS(B2-C2)<=1,"match","no match")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SMac" wrote in message
...
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