Thread
:
Data falls in a range +/-1
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
vezerid
Posts: n/a
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
Reply With Quote
Data falls in a range +/-1