In this tutorial, we will look at how to calculate Percentile IF in the table in Excel Office 365. We will show you the easy steps for completing the task quickly. Utilize the below-mentioned formulas!!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel.
Generic Formula
- You can use the below-mentioned formula to calculate Percentile IF in the table.
=[PERCENTILE](https://geekexcel.com/how-to-use-excel-percentile-function-in-office-365-with-examples/)(IF(criteria,values),k)
Syntax Explanation
- Parenthesis () – The primary purpose of this symbol is to group the elements.
- *Comma symbol (,) *– It is a separator that helps to separate a list of values.
- *PERCENTILE *– This function returns the Kth percentile of the given set of data.
Practical Example
- For instance, you need to create sample data in Excel.
Sample data
- Then, you have to calculate the Percentile 90 % for males and females using the formula below.
=[PERCENTILE](https://geekexcel.com/how-to-use-excel-percentile-function-in-office-365-with-examples/)(IF(Table[Gender]=G$4,Table[Score]),$F5)
Use the Formula
- Now, you will get the result as given below in the Excel.
Result 1
- After that, you need to calculate the Percentile 80 % for males and females using the formula below.
=[PERCENTILE](https://geekexcel.com/how-to-use-excel-percentile-function-in-office-365-with-examples/)(IF(Table[Gender]=G$4,Table[Score]),$F6)
Use the Formula
- Then, you will get the result as given below in the Excel.
Result 2
- Now, you have to calculate the Percentile 70 % for males and females by using the formula below.
=[PERCENTILE](https://geekexcel.com/how-to-use-excel-percentile-function-in-office-365-with-examples/)(IF(Table[Gender]=G$4,Table[Score]),$F7)
Use the Formula
- Finally, you will get the result as given below in the Excel.
Result 3
From this tutorial, we described the formulas to calculate Percentile IF in the table ** in Excel Office 365. Hope that this article is helpful to you. If you have any **doubts/queries, feel free to share them with us. Thank you so much for Reading!! Keep learning on Geek Excel !! ** And Excel Formulas **!!
Further Reference:
Top comments (0)