I am having difficulty writing the Nested function. The formula I used was =IF(B2 8. In the "Order Quality Nested" column, create a Nested IF function to rank the customer sales by the average sales per order. If the average sales amount per order is less than $20, rank as Low, $20 to less than $40 "Average," $40 to less than $100 as "High," and over $100 as "Prime." 1 Total Annual Sales Number of Orders Order Quality Nested $315,044.33 66385 $13,444.68 2172 $181,120.24 35696 $69,608.15 15205 $30,940.35 7833 $74,321.18 14328 $18,474.15 4677 $80,890.34 17790 $31,746.70 5057 $103,244.26 20958 $160,227.13 33535 $67,179.39 12959 $181,287.73 33799 $133,617.26 25788 $186,696.56 36190 $118,193.46 24532 $72,891.83 11891 $12,469.92 1992 $96,009.15 17404 $137,602.28 25750 $11,637.34 1859 $12,843.90 2010 $103,089.33 20010 $13,036.14 2106 $340,867.26 61779 $138,986.22 26047 $20,358.30 5154 $120,190.31 23738 $64,370.58 12422 $74,254.93 14899 $278,106.13 52875 $17,421.46 2842 $96,692.34 17590 $49,298.46 9594 $78,856.60 15256