Trying to combine below statement, appreciate assistance...
IF(OR(C5="",I5=""),"",IF(OR(WEEKDAY(C5)=7,WEEKDAY(C5)=1),"",IF(I5="F",7,5)))
IF(OR(C5="",I5=""),"",IF(AND(WEEKDAY(C5)<>7,WEEKDAY(C5)<>1),"",IF(I5="F",7,6)))
A part timer work on weekday (Mon - Fri) will be pay 5 and 6 on weekend (Sat and Sun), whereas a full timer will be pay 7 either weekend or weekday.