Multiple If statements needed

[cwheeler116]

I am trying to create this workbook (see attached file) to automatically change Column P on the tracking tab based upon the following logic

1. If inspection type (Data column H) is "Normal" and FM is found, then inspection status (Tracking Column P) goes to "AQL"
2. If inspection status (Tracking Column P) is "AQL" and there are 7 consecutive lots with no findings, inspection status (Tracking Column P) to "Normal"
3. If inspection status is "Normal" and there is a recieving failure (Tracking Column Q), then inspection status to "AQL"
4. If inspection status is "AQL" and there are FM findings in 2 out of 5 consecutive lots, then inspection to "Tightened"
5. If inspection Type is "Tightened", and 3 consecutive lots with no FM findings, then Inspection to "AQL"

A consecutive lot is any line entry on the Data tab from the same EST # (Data Column D)

Thanks in advance for any light that can be shed

[BB1972]

cwheeler116,

What do you mean in 1 above "and FM is found"? There are 4 columns which contain "FM" in their headings - do you mean if there's a value greater than 0 in any those 4 columns?