I am setting up a spreadsheet to do some stats and am lost on a large
if,and,or type statement

The columns are
E=Start of period
F=end of period
H=Completed
Q=Target achivied
N=Waived
O=Deferred
M=FTA
P=Exit

U=Exit

The other columns dont really matter as they wont affect what i want

The Result in Col Q needs to Be Pass or Fail

The scenario is as follows.

If the interivew is completed within the target window (E-F) we pass
If we waive the interview (N) we pass
IF we FTA the interview (M) we fail unless there is an entry between E-F in
completed (H)
If we Defer the interview outside the target window we fail but if it is
inside & we complete the interview we pass
If we Exit (P) thne i want no entry at all in Col Q

i think that is all. I got so far then gave up. If i cnt do one large
statement should i do lots of little ones with outcomes in hidden columns?

hopefully this makes sense