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