View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SMac
 
Posts: n/a
Default 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