I'm doing a project for a computer class and I have a group of hypothetical employees.

There are three columns: employee, hours worked, and wage. Is there a way to format the employee's name so that when I type it and hit enter, it calculates their hours worked for that day multiplied by their hourly rate?

Any help would be greatly appreciated!! Thanks!

Like this?

Attached Files

Wage.xlsx (13.8 KB, 21 views)

Sort of. I did think about having a column for hourly rate and formatting the wage column to calculate hours*hourly rate, however I am also having columns for things like overtime, sick, and being late. I wanted to keep the table as streamlined as possible, minimize the amount of columns, if that makes sense? I also thought I could have their wage rate on a separate sheet and have the formula for wage reference the info on that sheet. Ideally though, I would like to be able to type in the name of the employee and that name is formatted to calculate their hourly rate by referencing the hours listed in a given row. I know you can name a cell or a group of cells, but couldn't figure out how to attribute a formula to a name that you type into a cell. I don't know if this is possible but it would make things so much easier if it were!!

Try to set up your sheet as you want it, upload the file and I shall see if I can help with a formula (please mention if you enter hours as for example 7 instead of 7:00).

That would be awesome, thank you! I have a busy weekend, so I'll probably upload it tomorrow or Monday

Here you go. Thanks again!

Attached Files

Payroll Project.xlsx (18.4 KB, 19 views)

Take a look at the attached.


Edit:

I forgot to multiply by hours so the formulas in F5 and G5 should be:

=IF([@Hours]="","",INDEX(Rates!$B$4:$B$8,MATCH([@Employee],Rates!$A$4:$A$8,0))*[@Hours])

=IF([@Hours]="","",INDEX(Rates!$C$4:$C$8,MATCH([@Employee],Rates!$A$4:$A$8,0))*[@Hours])

Attached Files

Payroll Project_2.xlsx (21.3 KB, 15 views)

I am so sorry for this late reply! I had two tests this week that monopolized my time and the notifications for this website go in my junk mail. I really appreciate your input on this, so thank you for the time you're spending trying to figure it out!!

Attached Files

Payroll Project_2.xlsx (21.5 KB, 10 views)