Excel Formulas to Calculate Percentile IF in Excel table!!
Tags: excelformula, excelformulas
Published: 2021-11-16 05:06:25

---
title: Excel Formulas to Calculate Percentile IF in Excel table!!
published: true
date: 2021-11-15 07:04:53 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-percentile-if-in-excel-table/
---

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](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 **](https://geekexcel.com/how-to-use-excel-percentile-function-in-office-365-with-examples/)– This function returns the Kth percentile of the given set of data.

## Practical Example

- For instance, you need to  **create sample data**  in Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-60.png)
_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)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-for-Percentile-90.png)
_Use the Formula_

- Now, you will get the **result** as given below in the Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-1-1.png)
_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)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-Formula-for-Percentile-80.png)
_Use the Formula_

- Then, you will get the **result** as given below in the Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-2-1.png)
_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)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-for-Percentile-70.png)
_Use the Formula_

- Finally, you will get the **result** as given below in the Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-3-2.png)
_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**](https://geekexcel.com/) **!! ** And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Further Reference:**

- **[Excel Shortcut: INSERT TABLE in the Worksheet in Excel 365!!](https://geekexcel.com/ms-excel-shortcut-to-insert-table-in-the-worksheet/)**
- **[Convert a Table to the Data Range in Excel Office 365!!](https://geekexcel.com/convert-table-to-data-range/)**
- **[Excel Formulas to Count table columns in Excel 365!!](https://geekexcel.com/excel-formulas-to-count-table-columns-in-excel-365/)**
- **[Excel Formulas to Get column index in Excel Table ~ Quickly!!](https://geekexcel.com/excel-formulas-to-get-column-index-in-excel-table-quickly/)**