Region Salesperson 1 Quebec Salesperson 2 Ontario Sales Commission Salesperson 3 Ontario Salesperson 4 Ontario Salesperson 5 Ontario Salesperson 6 Quebec Salesperson 7 Quebec Quebec Ontario 0 0% 0 1% 250000 2% 300000 2% 400000 3% 400000 3% 600000 4% 500000 4% 750000 5% 600000 5% 1000000 7% 700000 6% 800000 7% 900000 8% 9% Salesperson 8 Quebec Salesperson 9 Ontario Salesperson 10 Ontario Salesperson 11 Ontario Salesperson 12 Ontario Salesperson 13 Ontario Salesperson 14 Quebec Salesperson 15 Quebec Salesperson 16 Ontario This is a payroll template for a real estate company that operates in Ontario and Quebec. There are two different Commission schemes, one for Ontario and the other for Quebec. Your role is to calculate the commission for each Salesperson. Ideally, you are required to use an if and a Vlookup statement combined, anything else will not earn you any marks. 1000000 Salesperson 17 Ontario Salesperson 18 Quebec Salesperson 19 Quebec Salesperson 20 Ontario