excel pentile formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2860130%22%20slang%3D%22en-US%22%3Eexcel%20pentile%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2860130%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20to%20find%20a%20pentile%20formular%20it%20gives%20me%20an%20error%20code%20even%20when%20the%20formula%20is%20entered%20as%20should%2C%20%3DPercentile(c5%3Ac35%3B0.25)%20%2C%20what%20am%20I%20doing%20wrong%20here%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EG.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2860130%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2860224%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20pentile%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2860224%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1189546%22%20target%3D%22_blank%22%3E%40gmala690%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%26nbsp%3B%3CEM%3E%3CSTRONG%3E%3DPercentile(c5%3Ac35%3CFONT%20color%3D%22%23FF0000%22%3E%2C%3C%2FFONT%3E0.25)%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Eor%3CEM%3E%3CSTRONG%3E%26nbsp%3B%3DPercentile(c5%3Ac35%3B0%3CFONT%20color%3D%22%23FF0000%22%3E%2C%3C%2FFONT%3E25)%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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)