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

Data falls in a range +/-1
 

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

HTH
Kostis Vezerides

Data falls in a range +/-1
 

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

Data falls in a range +/-1
 

=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