Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Monter IF statement??? sorry long question
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't add 7th IF statement to long formula. | Excel Worksheet Functions | |||
IF statement too long, need another way | Excel Worksheet Functions | |||
very long statement | Excel Discussion (Misc queries) | |||
IF statement too long | Excel Discussion (Misc queries) | |||
Long IF Statement | Excel Discussion (Misc queries) |