8 2 On the Commission worksheet, in cell B4, troubleshoot and edit the function so that it retrieves the correct value of 5.00% B4 X =VLOOKUP(B3,04:58,2,FALSE) B D E H Event Earnings Calculator 1 2 3 Cost of Event 4 Commission Percent s Commission Eamed $17,000.00 #N/A #N/A Cost of Event 0 5000 10000 15000 poo Commission Percentage 0.00% 1.00% 3.00% 5.00% 8.00% Manager $ 750 7 Employee Level 8 Base Event Pay 9 10 Total Earnings 11 12 13 14 #N/A Level Base Event Pay Entry S 500 Consultant s 750 Senior Consultants 1,000 Manager $ 1,250 Senior Manager $ 1,500 16 17 18