Excel Forum

Excel Magic Trick 725: Which Quartile Are You In? INPUT your Score, Formula Says Quartile You Are In

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn about the QUARTILE function. Learn how to create a formula that will automatically tell you what quartile a particular score is in using the MATCH and QUARTILE functions and an array constant.

Got a Question? Ask it Here in the Forum.