cancel
Showing results for 
Search instead for 
Did you mean: 

unexpected N\A from PERCENTILE function

bminehart
9 - Travel Pro
9 - Travel Pro

We sometimes received N\A results from a PERCENTILE calculation, even though with the same dataset we will get results from other statistical functions like AVG or MEDIAN.

I'm wondering if this has to do with a minimum number of values requires to calculate PERCENTILE? Is this defined anywhere? I don't see it in the online function reference.

Is there some other common cause for getting an N\A result for PERCENTILE?

0 REPLIES 0