Forum Discussion
Simple persentile formula not working
Why is the formula not working?
LFM123 The quality of the screen shot it not good enough to read what it says. What formula did
you use? What was the error message and how does the underlying data look like?
I used this formula: =PERCENTILE.INC(D3:D31,1-L2) for a certain numerical rows. The error message is that there is a problem with this formula.
LFM123 Judging by your name, you are from a Nordic country and perhaps need to use the semi-colon to separate arguments withing a formula.