can you help me with number 5. I don't know how to put a formula with if function. can you show me how to do it. thank you. show the formula in exel plz. thank you

> > Brov Paste a. A- ESS $ 9088 Formatting as Table Styles Format Filter Sale 17 x fx o M K P N Q R G H B D 1 2 Expected Volume: 3 Rebates E F Total 390 1,615 BO 400 75 410 BO 4115 85 5 Quarterly Sales Volumes Q1 a3 02 04 Best in Class 20 Dealer ON oo + 9 10 1.111 3321 3322 3323 3324 3325 3326 3327 3376 3320 3330 3331 3332 3333 3134 211 19 433 315 284 501 21 536 371 383 210 185 499 128 400 270 Annual Total Quality of Sales Shipping Shipping Shipping Shipping Shipping Volume 40 Volume Rebate Q1 Rebate Q2 Rebate 03 Rebate 04 Rebato Estimate 477 1,891 32.475 41,680 36,800 38,160 149,115 243 1,370 0 33,120 0 33,120 205 880 0 0 0 0 259 1,784 37.575 34,320 0 36,720 108,615 157 0 0 0 0 0 1,230 40.200 0 40,200 504 1.795 0 39,680 38,720 40,320 118,720 365 1,060 0 0 409 1,208 0 0 0 0 510 1,545 0 39,600 40,800 80,400 390 1,441 37,425 0 37,425 189 742 0 0 0 0 0 390 1,615 33,200 33.200 291 0 0 0 0 30 521 460 414 398 T19 272 429 395 339 294 249 234 496 484 210 102 406 355 495 325 227 200 219 410 415 339 297 183 OOC OOOOOOO -OOOOO oc 1.197 12 13 14 15 16 17 18 19 20 21 22 28 24 25 26 27 26 29 30 31 32 33 34 35 38 large Calculate the value of the shipping rebate for each dealer for each quarter (use four columns). This should require only one formula that can be copied down the column and across the row. Be sure your inputs are set up so that this can be casily womplished. Remember, dealers will only receive rebates in quarters where their actual quarterly sales volumes exceeded expected sales volumes. In an adjacent column, determine the total value of the shipping rebate for all four quarters by dealership. 5. Analyze the quality of these volume estimates by categorizing the quality of the annual volume estimate versus the actual annual volumes for each dealership into the Applying Logic in Decision Making but based on Chapter 4 Collows: 4 CW lumes: These to pass along each quarter ial volume); ter, $80 per sis, only for er. Expected 4 following categories: Display Excellent" if the estimate is within 10% (higher or lower) of the actual sales volume. (Hint. For example, if you wanted to determine if the estimated value 26 is within +/- 25% of the sales value of 40, you would need to test this value to make sure that both 26>=40-25*40 and 26