I need help with this part. all the formulas that I have used with if function come out with an error #value. can you use the if function in exel to show me how to do it. thank you. show your formula in exel.

Promo Large Deals AutoSave Nuke's Top 5 www.youtube.com 5 SCARY Oost With Data Review Formulas View Tell me Page Layout ame Insert Draw General 8. - A M == Arial 2 Wrap Text Merge & Center Insert Delete Format $ %) Conditional Format Cell Formatting as Table Styles lili BIU x R o P N L M J G H B D E F Total 390 1,615 80 nected volume 400 75 410 BO 415 85 Quarterly Sales Volumes Rebate Q1 Robato Q2 Robato Q3 Rebate Q4 Best in Class 20 alent 339 3321 3322 3323 3324 3325 33326 3327 3326 3329 3330 3331 3332 3333 3334 10 433 315 284 501 321 536 311 383 210 185 499 126 30 521 480 398 119 272 420 395 294 249 234 496 484 210 102 406 183 365 495 325 227 208 219 410 415 339 297 Annual Sales 40 Volume 477 1,891 243 1,370 205 BBO 459 1.784 157 1,111 211 1,230 504 1,795 365 1,060 409 1,208 510 1,545 390 1,441 189 742 390 1,615 291 1,197 Total Quality of Shipping Shipping Shipping Shipping Shipping Volume Rebate 1 Rebate Q2 Rebate Q3 Rebate Q4 Rebato Estimato 32,475 41.680 36,800 38,160 149,115 Good 0 0 33,120 33,120 Good 0 0 0 0 O Poor 37,575 34,320 0 36,720 108.615 Exellent 0 0 0 0 O Poor 0 40.200 0 0 40.200 Poor 39.680 38,720 40.320 118,720 Good 0 D 0 0 O Poor 0 0 0 O Poor 0 39,600 40.800 80,400 Exellent 37.425 0 0 37,425 Good 0 O Poor 33,200 0 33,200 Exellent 0 0 O Poor OOO 400 270 - 4th Quarter: 390 An overall sales volume bonus based on exceeding expected annual volumes: Dealerships that exceeded the expected annual sales volume by more than 15% are awarded a $10,000 bonus. Dealerships that exceeded the expected annual sales volume by 15% or less are awarded a $5,000 bonus. Otherwise, no bonus is awarded (S0). A "Best in Class bonus of $8,000 awarded to the one dealership with the highest overall sales volume in its class You have been asked to set up a worksheet to record the dealer information for the past year