IF CONDITION to mark PRESENT, ABSENT and LATE COMING

[uswyne]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]Day[/TD]
[TD="align: center"]Time In[/TD]
[TD="align: center"]Time Out[/TD]
[TD="align: center"]Remarks[/TD]
[TD="align: center"]Formula[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]7:50:01[/TD]
[TD]14:30:35[/TD]
[TD]Present[/TD]
[TD]=IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present")))[/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD]9:02:01[/TD]
[TD]14:00:45[/TD]
[TD]Late Coming[/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]=IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present")))[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
[TR]
[TD]Sunday[/TD]
[TD]OFF DAY[/TD]
[TD]OFF DAY[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]7:51:01[/TD]
[TD]15:00[/TD]
[TD]Late Coming[/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]=IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present")))[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD][/TD]
[TD][/TD]
[TD]Absent[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]

For Late Coming and Present I use above mentioned formula. but what would be the formula to mark Absent If Cell B is Blank?

 

[Gerald Higgins]

Perhaps

=if(B3="","Absent",IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present"))))

 

[uswyne]

Thank you very much, some time mind won't work?