I need your help to complete the VLOOKUP formula I need to SUM the salary and the commission (Commission is computed by multiplying a commission rate times the sales.)
I tried to use the following information to set up the table.
Employees in department 200 receive a $10,000 salary and a 2% commission.
Employees in department 300 receive a $5,000 salary and a 4% commission.
Employees in department 100 receive a $15,000 salary and a 1% commission.
Employees in department 400 receive a $8,000 salary and a 5% commission
I guess I can add the functions.
Name Dept Sales Check Amount
Mary 200 4,000.00
Sue 400 500.00
George 300 1,000.00
Istar 100 2,000.00
TOTAL $ 7,500.00 $ -
Table to Compute Check: