Forum Discussion
Tracking Profit
Let's say you create a new worksheet in the same workbook and name it Rates.
In A1, enter Employee and in B1, enter Hourly Rate.
In A2, A3 etc., enter the names of the employees (Jonathan etc.).
In B2, B3 etc., enter the corresponding hourly rates.
Go back to the profit sheet.
Enter the following formula in T2:
=J2-I2*IFERROR(VLOOKUP(P2, Rates!$A$2:$B$1000, 2, FALSE), 0)
If you want to take multiple crew members into account, please provide more detailed information about the setup.
Let's say you create a new worksheet in the same workbook and name it Rates.
In A1, enter Employee and in B1, enter Hourly Rate.
In A2, A3 etc., enter the names of the employees (Jonathan etc.).
In B2, B3 etc., enter the corresponding hourly rates.
Go back to the profit sheet.
Enter the following formula in T2:
=J2-I2*IFERROR(VLOOKUP(P2, Rates!$A$2:$B$1000, 2, FALSE), 0)
If you want to take multiple crew members into account, please provide more detailed information about the setup.
