What is the =vlookup formula to calculate Commission Amount ? Use the VLOOKUP function in cell C2
Fantastic news! We've Found the answer you've been seeking!
Question:
What is the =vlookup formula to calculate Commission Amount ?
Use the VLOOKUP function in cell C2 to calculate the commission amount (dollar amount of commission) for the first salesperson based on the information in cells E7:G13. Hint: The VLOOKUP function just returns the commission rate. You need to perform some extra math/calculation to calculate the commission amount.
Salesperson Name | House Price | Commission Amount | ||||
Ann White | $68,000.00 | |||||
Bill Brown | $579,000.00 | |||||
John Doe | $123,000.00 | |||||
Mary Smith | $347,000.00 | |||||
Joan Rivers | $42,900.00 | Price | Commission Rate | Real Estate Company | ||
Robert Jackson | $200,000.00 | $25,000.00 | 3% | Century 21 | ||
$40,000.00 | 5.30% | ReMax | ||||
$75,000.00 | 6.10% | Williams | ||||
$100,000.00 | 10% | Higgins | ||||
$230,000.00 | 13.40% | Rand | ||||
$350,000.00 | 25% | Ravis | ||||
$500,000.00 | 31% | Weichert | ||||
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date: