Thread: [Solved] Is there a way in Excel to type a person's name in a cell and have it calculate their gross pay?
View Single Post
 
Old 02-19-2017, 11:12 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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
File Type: xlsx Payroll Project_2.xlsx (21.3 KB, 15 views)
Last edited by xor; 02-20-2017 at 01:29 AM.
Reply With Quote