excel pentile formula

Copper Contributor

Good day,

 

I am struggling to find a pentile formular it gives me an error code even when the formula is entered as should, =Percentile(c5:c35;0.25) , what am I doing wrong here?

 

G.

1 Reply

@gmala690 

Try =Percentile(c5:c35,0.25)

 

or =Percentile(c5:c35;0,25)