Maximum data points for PERCENTILE function?

D

Don Wiss

In the help for the PERCENTILE function it has "If array is empty or
contains more than 8,191 data points, PERCENTILE returns the #NUM! error
value." But it appears to work for much longer columns. Is the help wrong?
Or am I missing something?

I'm using xl2002.

Don <www.donwiss.com> (e-mail link at home page bottom).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top