# 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

## Files

• Hi,

If I am not mistaken, you could make your life a lot easier with the function =WEEKNUM(C2)

Let me know if it helps

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

Edited once, last by Carim ().

• 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

• Sorry ... I meant complete Replace ...

Have you had a look at the attached file ?

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• PERFECT again, Thanks!

Glad this issue could be fixed

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• 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

 Olivia Goughan \$36.00 Olivia Goughan \$36.00 Olivia Goughan \$36.00 Olivia Goughan\$36.00 Taylor Wood \$37.00 Taylor Wood \$37.00 Zoe Schreiber \$38.00 Elizabeth Crosley \$30.00 Elizabeth Crosley \$30.00

## Files

Edited once, last by PETRODATAjames ().

• Hi again,

So this means your Pay rates are linked to the Names .... and NOT to the Week Numbers ....

Modification attached

Code
``=INDEX('Pay Rates'!\$B\$1:\$B\$50,MATCH(B2,'Pay Rates'!\$A\$1:\$A\$50,0))``

Hope this will help

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• PERFECT again, thanks!

This has been resolved.

• Pleased to hear you have also fixed this issue

Thanks for your Thanks AND for the Like

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!