Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
data range props | Excel Discussion (Misc queries) | |||
data range | Excel Discussion (Misc queries) | |||
Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |