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-25-2017, 01:46 PM
jllee14 jllee14 is offline Windows 10 Office 2013
Novice
  
Join Date: Feb 2017
Posts: 8
jllee14 is on a distinguished road
Default
That is exactly what I had in mind!! Ah, thank you! Now I just have two questions at the moment:
-If I need to add more employees, and let's say that takes it down to row 14 in the Rates table. I would then just change your formula to

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

and

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

right?

-Do you mind explaining this in case I need to do something similar in the future?
Reply With Quote