 # PERCENTRANK.EXC

In this comprehensive article, we will explore the PERCENTRANK.EXC function in Excel, which calculates the relative standing of a specified value within a dataset. This function is particularly useful when you want to determine the percentile rank of a value, excluding the highest and lowest values in the dataset. We will cover the syntax, examples, tips and tricks, common mistakes, troubleshooting, and related formulae for the PERCENTRANK.EXC function.

## PERCENTRANK.EXC Syntax

The syntax for the PERCENTRANK.EXC function in Excel is as follows:

PERCENTRANK.EXC(array, x, [significance])

Where:

• array – This is a required argument, representing the range of data you want to analyze.
• x – This is a required argument, representing the value for which you want to find the percentile rank.
• significance – This is an optional argument, representing the number of significant digits to which you want to round the result. If omitted, Excel will use a default value of 3.

## PERCENTRANK.EXC Examples

Let’s look at some examples of how to use the PERCENTRANK.EXC function in Excel:

Example 1: Suppose you have a dataset of test scores for a class of 20 students, and you want to find the percentile rank of a student who scored 75 points, excluding the highest and lowest scores.

=PERCENTRANK.EXC(A1:A20, 75)

In this example, the function will calculate the percentile rank of the student with a score of 75, excluding the highest and lowest scores in the range A1:A20.

Example 2: If you want to round the result to 2 significant digits, you can include the optional significance argument:

=PERCENTRANK.EXC(A1:A20, 75, 2)

This will return the percentile rank rounded to 2 significant digits.

## PERCENTRANK.EXC Tips & Tricks

Here are some tips and tricks to help you get the most out of the PERCENTRANK.EXC function:

• Remember that the PERCENTRANK.EXC function excludes the highest and lowest values in the dataset. If you want to include these values, use the PERCENTRANK.INC function instead.
• When using the optional significance argument, be cautious not to set it too high, as this may cause the result to be less accurate.
• If you want to find the value corresponding to a specific percentile rank, you can use the PERCENTILE.EXC function.

## Common Mistakes When Using PERCENTRANK.EXC

Here are some common mistakes to avoid when using the PERCENTRANK.EXC function:

• Not specifying the required arguments (array and x) correctly. Ensure that you provide a valid range for the array and a valid value for x.
• Using the PERCENTRANK.EXC function when you actually want to include the highest and lowest values in the dataset. In this case, use the PERCENTRANK.INC function instead.
• Using the wrong function to find the value corresponding to a specific percentile rank. For this purpose, use the PERCENTILE.EXC function.

## Why Isn’t My PERCENTRANK.EXC Working?

If you’re having trouble with the PERCENTRANK.EXC function, consider the following troubleshooting steps:

• Double-check the syntax of your formula, ensuring that you have provided the correct arguments.
• Make sure your dataset does not contain any errors, such as text values or blank cells, which may cause the function to return an error.
• Ensure that you are using the correct function for your needs. If you want to include the highest and lowest values in the dataset, use the PERCENTRANK.INC function instead.

## PERCENTRANK.EXC: Related Formulae

Here are some related formulae that you may find useful when working with the PERCENTRANK.EXC function:

• PERCENTRANK.INC: This function calculates the percentile rank of a value within a dataset, including the highest and lowest values. Syntax: PERCENTRANK.INC(array, x, [significance])
• PERCENTILE.EXC: This function returns the value corresponding to a specific percentile rank, excluding the highest and lowest values in the dataset. Syntax: PERCENTILE.EXC(array, k)
• PERCENTILE.INC: This function returns the value corresponding to a specific percentile rank, including the highest and lowest values in the dataset. Syntax: PERCENTILE.INC(array, k)
• QUARTILE.EXC: This function returns the value corresponding to a specific quartile, excluding the highest and lowest values in the dataset. Syntax: QUARTILE.EXC(array, quart)
• QUARTILE.INC: This function returns the value corresponding to a specific quartile, including the highest and lowest values in the dataset. Syntax: QUARTILE.INC(array, quart)

By understanding and mastering the PERCENTRANK.EXC function and its related formulae, you can efficiently analyze and interpret data in Excel, allowing you to make more informed decisions based on your findings.

## Related ### Hard to find or retain a good accountant? Try cloud accounting solution

Foreign business owners or management team always take financial transparency as a pre-condition for good decision making and sustainable profitability. However, achieving the visualization of ### Cloud Accounting Software Automates Compliance Service in China

Managing accounting compliance in China can be a challenging task for businesses, as it involves dealing with complex regulations and paperwork. However, the advent of 