Formula Problem - if statement

  • Thread starter Thread starter Richard Bleier
  • Start date Start date
R

Richard Bleier

I am trying to create a scheduling formula which alerts me if there are
scheduling conflicts. I have 4 different dates which a 5th date cannot
match. In addition, it cannot conflict with the 4th date and including 35
days prior. For example:

B2 = Inventory Date (cannot conflict with this date and 35 days prior)
C2 = Reset 1 Date - (cannot match this date)
D2 = Reset 2 Date - (cannot match this date)
E2 = Reset 3 Date - (cannot match this date).

The formula I have is:
=IF(F2="","",IF(F2=C2,"Reset 1 Conflict",IF(F2=D2,"Reset 2
Conflict",IF(F2=E2,"Reset 3 Conflict",IF(F2=B2,"Inventory
Conflict",IF(B2-35<F2,"Inventory Conflict","No Conflict"))))))

This covers all criteria I need except: It flags all dates after the
inventory date as an "Inventory Conflict". The only dates it should flag
after this date are if they match Reset 1, 2 or 3. I need to eliminate the
"Inventory Conflict" flag after the B2 (Inventory) Date unless they match
C2, D2, or E2.

Thanks
 
Try this minor change instead...
=IF(F2="","",IF(F2=C2,"Reset 1 Conflict",IF(F2=D2,"Reset 2
Conflict",IF(F2=E2,"Reset 3 Conflict",IF(F2=B2,"Inventory
Conflict",IF(AND(B2<=F2,B2>=(F2-35)),"Inventory Conflict","No Conflict"))))))
 
I may have misunderstood your scenario; if I did, the F2's and B2's in the
And() statement may need to be reversed.
 
Back
Top