The Percentile Exc function in Excel is a statistical function, and its purpose is to return the k-th Percentile of values in a range, where k is 0 to 1. The formula for the Percentile.

Excel doesn't have a specific function to determine quintiles, but you can use the PERCENTILE function to get your desired result.

Excel Functions for Adding a Percentage Markup. Microsoft Excel provides numerous mathematical functions that save time and improve accuracy in data entry. Percentage markups are used in retail ...