If and statements with 3 arguments

[trosasco23]

I'm working on a formula to calculate a timesheet. This is a special timesheet. Some people get paid cash as contractors and others go into payroll through a payroll company. Also any OT time is paid in cash as well. I have half of this formula figured out.

This formula is in column J:
=IF(AND(A9="ON",K9>40),-40,K9)

I'm working on row 9 for this example...It basically states - if this person is ON the payroll, and the TOTAL HOURS are over 40 hours, (like in this case 41 hours), then enter only 40 hours but as negative number... which in turn will calculate 1(one) OVERTIME hour for the "Live" check to be written for the remaining hour; if not then enter TOTAL HOURS = column K.

What I need to do is add a second statement saying: if the person is still ON the payroll but is under 40 TOTAL HOURS, then enter the TOTAL HOURS but as a negative number (working on row 6 for this example)

I also need to add a third statement saying: if the person is OFF the payroll, then leave blank. Is this even possible? I'm attempting to attach the file but I cant for some reason.

[shijithraj]

Can you try this in J6 =IF(A6="OFF","",IF(K6>=40,-40,IF(K6<40,-1*K6,"")))

[mehmetcik]

Please Login or Register  to view this content.

[newdoverman]

Maybe this will work for you...no time to fully check.

Please Login or Register  to view this content.

[trosasco23]

Wow, you guys are all amazing. All formulas worked perfectly. Thank you.