In Post #5 of this thread the OP would like to calculate the 95th percentile of the data (194000 rows) using the LOGINV function.
The problem as far as I can tell is the presence of #NUM errors in the data, E15671:E19044 (among other places), however I may be missing something and feel that there may be others that are more well versed in statistical analysis that could offer help.

https://www.excelforum.com/excel-for...ml#post4720083