Payroll Formula Help

[JackChang]

All-

I need help with a payroll formula that meets the following criteria:
If an employee works less than 25 hours per week, anytime in the past 26 consecutive weeks, and his group life is active (column B will show "Employee Life"), then it needs to be cancelled because he did not meet the criteria.

For example, on the file attached, column B shows if the user has an active group life when the field shows "Employee Life", blank means they do not have group life. Columns D-AC shows 26 weeks of hours worked. If the user does not meet the above criteria, I would like column C to show a cancel. In this case, such as on row 25 & 26, it should be cancelled because he did not work more than 25 hours, and he has an active group life. But, on row 18, there is no changes because although he worked less than 25 hours per week in the past 26 weeks, his group life (col B) is blank and not active, so there is nothing to cancel.

Does anyone have any ideas how I can create a formula for this?

Thank you,

[arnelgp]

You can write a formula in C2:

=IF(AND(OR(D2<25,E2<25,F2<25,G2<25,H2<25,I2<25,J2<25,K2<25,L2<25,M2<25,N2<25,O2<25,P2<25,Q2<25,R2<25,S2<25,T2<25,U2<25,V2<25,W2<25,X2<25,Y2<25,Z2<25,AA2<25,AB2<25,AC2<25), ISBLANK(B2)=FALSE),"CANCEL","")

[JackChang]

Yes, that works thanks arnelgp woohoo!
Hope you have a great evening.

[arnelgp]

:friends: