=PERCENTILE.EXC(array,k)

The PERCENTILE.EXC function syntax has the following arguments:



Argument


Description



array

Required

The array or range of data that defines relative standing.


k

Required

The array or range of data that defines relative standing.




Notes:

If array is empty, PERCENTILE.EXC returns the #NUM! error value


If k is nonnumeric, PERCENTILE.EXC returns the #VALUE! error value.


If k is ≤ 0 or if k ≥ 1, PERCENTILE.EXC returns the #NUM! error value.


If k is not a multiple of 1/(n + 1), PERCENTILE.EXC interpolates to determine the value at the k-th percentile.


PERCENTILE.EXC will interpolate when the value for the specified percentile lies between two values in the array. If it cannot interpolate for the percentile, k specified, Excel will return #NUM! error.



Example


Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.


See Also

PERCENTILE function

PERCENTILE.INC function

Excel functions (alphabetical)

Excel functions (by category)






Need more help?





Want more options?



DiscoverCommunity



Explore subscription benefits, browse training courses, learn how to secure your device, and more.






Microsoft 365 subscription benefits




Microsoft 365 training




Microsoft security




Accessibility center


Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.






Ask the Microsoft Community




Microsoft Tech Community




Windows Insiders




Microsoft 365 Insiders
















Was this information helpful?

Yes No


Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.)

What affected your experience?


Resolved my issue

Clear instructions


Easy to follow

No jargon


Pictures helped

Other



Didn't match my screen

Incorrect instructions


Too technical

Not enough information


Not enough pictures

Other

Any additional feedback? (Optional) To protect your privacy, do not provide any personal information such as email address, phone number, product key, password, or credit card number.

Submit feedback

By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.


Thank you for your feedback!
×







What's new
Surface Pro
Surface Laptop
Surface Laptop Studio 2
Copilot for organizations
Copilot for personal use
AI in Windows
Explore Microsoft products
Windows 11 apps


Microsoft Store
Account profile
Download Center
Microsoft Store support
Returns
Order tracking
Certified Refurbished
Microsoft Store Promise
Flexible Payments


Education
Microsoft in education
Devices for education
Microsoft Teams for Education
Microsoft 365 Education
How to buy for your school
Educator training and development
Deals for students and parents
AI for education



Business
Microsoft Cloud
Microsoft Security
Dynamics 365
Microsoft 365
Microsoft Power Platform
Microsoft Teams
Microsoft 365 Copilot
Small Business


Developer & IT
Azure
Microsoft Developer
Microsoft Learn
Support for AI marketplace apps
Microsoft Tech Community
Microsoft Marketplace
Marketplace Rewards
Visual Studio


Company
Careers
About Microsoft
Company news
Privacy at Microsoft
Investors
Diversity and inclusion
Accessibility
Sustainability

English (United States)