Spreadsheet: 488220d1478571575-average-if-and-help-average-if-and-help-v1
Sheet: Sheet1

 | Ratio: | Absolute Current TTM |  |  | Top Quartile | Second Quartile | Third Quartile | Fourth Quartile
 | PE Ratio | 17.54034828876413 |  | P/E Range | 10.26239539045665 | 14.59384680542105 | 16.4793245026332 | 17.75905426364362
 |  |  |  |  | 14.56848232981946 | 16.47158860096833 | 17.74531162312097 | 24.5185054354609
 |  |  | SD |  | 0.1532133116507089 | 0.1981205069204366 | 0.131322634072849 | 0.1332880305756708
 |  | Median | Performance |  | 0.1643944033427521 | 0.05833683846931548 | 0.09262807457392996 | 0.06424040637567752
 |  | Average | Performance |  | 0.1531204815347548 | 0.0003791519540705879 | 0.07207143633018513 | 0.04143518828499514
 |  |  | % Positive |  | 0.9047619047619048 | 0.5952380952380952 | 0.8333333333333334 | 0.7142857142857143
 |  |  | Return Risk |  | 1.072977286187336 | 0.2944512881381987 | 0.705347370069855 | 0.481966806008186
 | P/CF Ratio | 10.94623106368553 |  | P/CF Range | 4.85301067578261 | 8.576817035075985 | 10.03769345585335 | 10.79490515584507
 |  |  |  |  | 8.56084170560101 | 10.02494062542888 | 10.79215461806469 | 14.2033339492994
 |  |  | SD |  | 0.1886352826788128 | 0.1534034914268997 | 0.1227426805751436 | 0.1577260689470276
 |  | Median | Performance |  | 0.142161461803279 | 0.1206979148499313 | 0.06608109717340604 | 0.03158432339353079
 |  | Average | Performance |  | 0.1142343716992787 | 0.1174655307810218 | 0.04590171389620427 | -0.0105953582724991
 |  |  | % Positive |  | 0.8095238095238095 | 0.9047619047619048 | 0.7380952380952381 | 0.5952380952380952
 |  |  | Return Risk |  | 0.7536313450190324 | 0.7868003115655724 | 0.5383709795465228 | 0.2002479590367424
 | P/FCF Ratio | 17.38024330337074 |  | P/FCF Range | 7.296277925183747 | 13.61489343052847 | 16.6668248579588 | 18.486062730373
 |  |  |  |  | 13.4365503585538 | 16.59893664050861 | 18.45396938930926 | 33.12094220145242
 |  |  | SD |  | 0.1842328865727127 | 0.1451022008300746 | 0.1643569216869588 | 0.15718139629772
 |  | Median | Performance |  | 0.1348814854622116 | 0.09616353733151894 | 0.06608109717340604 | 0.09269992521425796
 |  | Average | Performance |  | 0.1025976618741665 | 0.09031679204912388 | 0.04611650174256484 | 0.02797530243815036
 |  |  | % Positive |  | 0.8095238095238095 | 0.9047619047619048 | 0.5952380952380952 | 0.7380952380952381
 |  |  | Return Risk |  | 0.732124909788985 | 0.662729695217604 | 0.4020584986330354 | 0.5897639758758308
 | P/BV Ratio | 2.650601581490126 |  | P/BV Range | 1.434295630410815 | 2.111991874176526 | 2.573348332921824 | 2.71145088294245
 |  |  |  |  | 2.104087734268437 | 2.568659901434938 | 2.711088941931775 | 3.193465481586509
 |  |  | SD |  | 0.1113440449123812 | 0.2149474069926283 | 0.1209765883390388 | 0.1324345706683689
 |  | Median | Performance |  | 0.1574675187540149 | 0.1373068938337429 | 0.08840145866317473 | 0.02625617386708257
 |  | Average | Performance |  | 0.1742244554170699 | 0.06102441461732479 | 0.05174126264730152 | -0.01998387457769062
 |  |  | % Positive |  | 0.9523809523809523 | 0.7619047619047619 | 0.7857142857142857 | 0.5476190476190477
 |  |  | Return Risk |  | 1.41424284413171 | 0.6387929761741761 | 0.7307319529910056 | 0.1982577036688629
 | P/Sales Ratio | 1.825212531940522 |  | P/S Range | 0.7164995742456892 | 1.268738607027595 | 1.444964037062657 | 1.541518358995105
 |  |  |  |  | 1.2637142235894 | 1.44304034167043 | 1.538076695438346 | 1.810754344621308
 |  |  | SD |  | 0.1534371462611386 | 0.2011936071887258 | 0.1262502508329514 | 0.1296048718896748
 |  | Median | Performance |  | 0.1484059347999436 | 0.1422598344208583 | 0.07965254969422508 | 0.02625617386708257
 |  | Average | Performance |  | 0.1447027373520348 | 0.09252084714745328 | 0.04106768805321079 | -0.01128501444869321
 |  |  | % Positive |  | 0.8809523809523809 | 0.8333333333333334 | 0.7619047619047619 | 0.5714285714285714
 |  |  | Return Risk |  | 0.9672099515417718 | 0.7070792974421608 | 0.6309100312174247 | 0.2025863185871048
 | EV/EBITDA | 11.47965740655247 |  | EV/EBITDA Range | 5.715708231301434 | 8.534040894094503 | 9.507830944747909 | 10.33258837206923
 |  |  |  |  | 8.530185955294023 | 9.50308056528549 | 10.32054313439552 | 11.9571008866432
 |  |  | SD |  | 0.1333324854180665 | 0.2039805271887793 | 0.1607698976958713 | 0.1134097426688404
 |  | Median | Performance |  | 0.1484059347999436 | 0.1323969240770568 | 0.07603370700759038 | 0.04429210871285216
 |  | Average | Performance |  | 0.1576184820511422 | 0.06292606221542044 | 0.0311719251974557 | 0.01528978863998733
 |  |  | % Positive |  | 0.8809523809523809 | 0.8095238095238095 | 0.6904761904761905 | 0.6666666666666666
 |  |  | Return Risk |  | 1.113051589300342 | 0.6490664864030208 | 0.4729349716414167 | 0.3905494155135008
 | EV/Sales | 2.224913354694125 |  | EV/SALES Range | 1.04119175308375 | 1.557022349918519 | 1.680033378498741 | 1.80529505205875
 |  |  |  |  | 1.552436826975078 | 1.67587972599382 | 1.799890340632932 | 2.117225284200176
 |  |  | SD |  | 0.1269520155301139 | 0.1656209729373534 | 0.1743310792687591 | 0.1298662759594078
 |  | Median | Performance |  | 0.1612697490152691 | 0.1261205612403311 | 0.07580645824417864 | 0.01991516221006628
 |  | Average | Performance |  | 0.1693160543861458 | 0.08892219492973293 | 0.02038828762734356 | -0.01162027883921676
 |  |  | % Positive |  | 0.9285714285714286 | 0.8571428571428571 | 0.7142857142857143 | 0.5476190476190477
 |  |  | Return Risk |  | 1.270320509224328 | 0.7615011493021272 | 0.4348419029019543 | 0.1533512997345912
 | FCF/Yield | 0.05753659385228856 |  | FCF Yield Range | 0.1370561826528581 | 0.07344897740864538 | 0.05999943051675356 | 0.05409480723858943
 |  |  |  |  | 0.07442386425942975 | 0.06024482300628619 | 0.05418888364360889 | 0.03019237779884619
 |  |  | SD |  | 0.1842328865727127 | 0.1451022008300746 | 0.1643569216869588 | 0.15718139629772
 |  | Median | Performance |  | 0.1348814854622116 | 0.09616353733151894 | 0.06608109717340604 | 0.09269992521425796
 |  | Average | Performance |  | 0.1025976618741665 | 0.09031679204912388 | 0.04611650174256484 | 0.02797530243815036
 |  |  | % Positive |  | 0.8095238095238095 | 0.9047619047619048 | 0.5952380952380952 | 0.7380952380952381
 |  |  | Return Risk |  | 0.732124909788985 | 0.662729695217604 | 0.4020584986330354 | 0.5897639758758308
 |  |  | SD |  | *I need a dynamic formula that will adjust if one or more of the multiples changes quartiles?
 |  | Median | Performance
 |  | Average | Performance
 |  |  | % Positive
 |  |  | Return Risk