perla1962
asked on
VLOOKUP Formula for Excel 2010
Hi,
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:
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:
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it works pretty much the same way as in your other six questions about Vlookup.