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
Assign the name Commissions_Table to the range E7:G13. Note: There is an underscore character between Commissions and Table.
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.
Copy the function/formula in cell C2 to cells C3 through C7.