I have a major nested IF statement problem. I need a cell to check the A column (Cells A2-A20) for a specific 9 digit number(already in cell F2). If it finds the number in Column A, it will look at the time (hh:mm) in the cell next to the cell with the number (a cell in column B). If the time is greater than or equal to 8:55, "ABSENT" will be displayed in the cell. This is the formula I have right now. Its not as scary as it looks considering its the same formula 15 times (it will check 15 cells for the 9 digit number). It is easy to understand why it doesn't work though. I appreciate any assistance! Here is the formula by itself: IF(A2=F2,IF(TIMEVALUE(TEXT(B2,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF...(if false it goes onto the next formula to check the next cell)

=IF(A2=F2,IF(TIMEVALUE(TEXT(B2,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A3=F2,IF(TIMEVALUE(TEXT(B3,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A4=F2,IF(TIMEVALUE(TEXT(B4,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A5=F2,IF(TIMEVALUE(TEXT(B5,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A6=F2,IF(TIMEVALUE(TEXT(B6,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A7=F2,IF(TIMEVALUE(TEXT(B7,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A8=F2,IF(TIMEVALUE(TEXT(B8,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A9=F2,IF(TIMEVALUE(TEXT(B9,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A10=F2,IF(TIMEVALUE(TEXT(B10,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A11=F2,IF(TIMEVALUE(TEXT(B11,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A12=F2,IF(TIMEVALUE(TEXT(B12,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A13=F2,IF(TIMEVALUE(TEXT(B13,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A14=F2,IF(TIMEVALUE(TEXT(B14,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A15=F2,IF(TIMEVALUE(TEXT(B15,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A16=F2,IF(TIMEVALUE(TEXT(B16,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A17=F2,IF(TIMEVALUE(TEXT(B17,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A18=F2,IF(TIMEVALUE(TEXT(B18,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A19=F2,IF(TIMEVALUE(TEXT(B19,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME")),IF(A20=F2,IF(TIMEVALUE(TEXT(B20,"hh:mm"))>=TIMEVALUE("8:55"),"LATE","ONTIME"),"ABSENT")