Hourly Payroll Template

I have this formula in column 'J' named 'Week'. It has this formula below.

[email protected](A2<>"",(IFS(AND(C2>='Pay Rates'!$D$2,C2<='Pay Rates'!$E$2),'Pay Rates'!$F$2,(AND(C2>='Pay Rates'!$D$3,C2<='Pay Rates'!$E$3)),'Pay Rates'!$F$3,(AND(C2>='Pay Rates'!$D$4,C2<='Pay Rates'!$E$4)),'Pay

This displays #NAME? in the cells. If I click on the ribbon, then click the menu name Formulas, and then the button named Insert Function, and click OK on the Function Arguments window, the cell now reads Week 1, Week 2, or Week 3 as it should. This will then allow the calculated data to appear on the "Pay Rates' tab and 'Hourly Summary' tab. I Googled the @ in an Excel formula and this @ in the formula was due to an Implicit Intersection. How can this formula be edited so column 'J' does not display #NAME? I have attached this workbook for review.

Thanks

May I ask, where I would add = WEEKNUM(C2) in this formula? [email protected](A2<>"",(IFS(AND(C2>='Pay Rates'!$D$2,C2<='Pay Rates'!$E$2),'Pay Rates'!$F$2,(AND(C2>='Pay Rates'!$D$3,C2<='Pay Rates'!$E$3)),'Pay Rates'!$F$3,(AND(C2>='Pay Rates'!$D$4,C2<='Pay Rates'!$E$4)),'Pay Rates'!$F$4)),"-")

Thanks

PERFECT again, Thanks!

This question has been answered.

Oh I just noticed something that maybe you can look at. I see on the tab 'Hourly Pay Data', column K has a Pay Rate formula. that is displaying an #N/A. Can this formula be edited to do a pay rate match from tab 'Pay Rates'? I would like the match be on the name and the just add the pay rate from that name match to Hourly Pay Data tab in column K. It would look like this: Thanks

PERFECT again, thanks!

This has been resolved.