Please help me figure out this formula? I currently have=IF(E4>200,2.25*E4)And(IF(E4

Guitar Universe Task #1 -- Create Bonus Formula Guitar Universe pays a bonus on any sale over $200. The current bonus percentage rate is in cell I1. If a sale is over $200, you just multiply the sale amount times the bonus percentage. If the sale is $200 or less, then the bonus is $0. Step 1 - Create a formula in cell F4 that calculates the bonus for that row. Warning: management likes to change the commission rate fairly often, so do not just type the current rate into your formula as a constant. Step 2 - Now copy that formula into the remaining rows [cells F5:F47}. Step 3 - Format the bonus amount cells to display with exactly 2 decimal places. Question: What bonus amount is displayed for Joshua in cell F31? Note: your answer should be exact to the penny, as displayed. No dollar signs or commas. please. Bonus Percentage 2.25% 1 GuitarUniverse - Sales Data Rate on Sales 2 Total Bonus 3 Date Salesperson Store # State Amount Bonus Amount Paid: 4 3/20/2019 Gina 2 FL 579.00 5 3/25/2019 Desiree 4 GA 43.00 6 4/6/2019 Jennifer 16 GA 91.00 7 4/8/2019 Jessica 8 FL 119.00 8 4/9/2019 Christopher 2 FL 56.00 9 4/10/2019 Olivia 18 NC 246.00 10 4/11/2019 Robert 11 GA 73.00 11 4/20/2019 Natasha 10 SC 53.00 12 4/22/2019 Joshua 2 FL 723.00 13 4/27/2019 James 8 36.00 14 4/27/2019 Melissa 14 SC 576.00 15 4/28/2019 Jennifer 12 FL 252.00 16 5/1/2019 Desiree 17 FL 19.00 17 5/2/2019 James 16 GA 240.00 18 5/6/2019 Cody 3 GA 220.00 19 5/11/2019 Achlev 14 sC 14 00 Sheet1 + Edit Accessibility: Good to go Type here to search O Ei W 9 X