Need to Apply two different condition in single formula to a Timelog Sheet

Hi,

For a attached time log sheet "Table 2", I would like to apply a formula with 2 different conditions.

Condition 1.= If a particular cell ( F22 as in attached sheet) show "Sat" or "Sun" ( Other than working day) then F23 cell show "WO" ( weekly Off)

Condition 2= in this if "Table 1" cell show any cell greater than "ZERO" then formula show that value, else if Cell show value equal to "ZERO" then "table 2", should show "L" as leave. Formula for that condition already applied to "Table 2" =IF(F10=0,"L",F10)

My requirement is that on Saturday and Sunday, Instead of "L", I need "WO" ( weekly Off).

Please help me for the same.

Hi & Welcome to the Forum.

Please change the formula in F23 as following and drag it across & down.

=IF(OR(TEXT(F$22,"DDD")="Sat",TEXT(F$22,"DDD")="Sun"),"WO",IF(F10=0,"L",F10))

Thanks a lot , Its work as per my requirement.

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.