Need some assistance with this spreadsheet please.

Paste - Format Painter Chipboard Arial 12 - AK EE. Wrap Test BIU-- A - A Es Merge & Center Font Alignment General $ % 4.23 Insert De Conditional Format as Cell Formatting Table Styles Styles 5 Number CE 013 B E G 1 2 C D Calculating car sales compensation Message Straight commission Commission w bonus 3 Number Average Car Price Number of Cars 4 1 $ 32.000 7 5 2 $ 27,500 9 6 3 S 34400 3 7 4 $ 23.900 12 8 5 $ 46,200 6 9 6 S 35 100 10 10 7 S 26,700 11 11 8 $ 30,700 5 12 9 $ 49.500 7 13 10 S 22.400 8 14 11 $ 26 300 6 15 12 $ 35 900 10 16 13 $ 26,700 4 17 14 S 21,600 5 18 15 $ 41,400 9 19 16 $ 36 500 11 20 21 Rules:Use the IF function to complete all 3 columns 22 For the 'Message' column: Message should be 'Bonus' if sales person sold 8 cars or more, otherwise No bonus! 23 For the 'Straight commission' column: Straight commission equals 3% of the total value of all cars sold Problem Problem 2 Problem 3 Type here to search o RI E a TALENTED motherfucker Autobe 9- BMG275 Mod 17 F Function - saved File Home Insert Page Layout Formulas Data Review View Hep And REF FU Poste Copy Xu In Format Pemes Clipboard 12 - AA== 2 Wrap Tot ESSE Merge Center Fort Apment Insert Delete Format $ . % - Conditional Formulas Cell Formatting Table Styles Number Styles Cels 013 X & 6 H 1 D F E A B 12 10 s 22,400 8 14 11 S 26,300 6 15 12 $ 35,900 10 16 13 S 26,700 4 17 14 S S 21,600 5 18 15 $ 41,400 9 19 16 $ 36,500 11 23 21 Rules: Use the IF function to complete all 3 columns 22 For the 'Message' column: Message should be 'Bonus' if sales person sold & cars or more, otherwise "No bonus 23 For the 'Straight commission' column: Straight commission equals 3% of the total value of all cars sold For the Commision wibonus' column: The Commission w/bonus should be straight commission, plus a bonus if the sales person sold at least 24 B cars. The bounis is 20% of commission 25 26 27 28 39 19 30 31 Problem 1 Problem 2 Problem 3 Type here to search O BI a W TALENTED