Fraktile function

S

SirSimons

I have date 2 different places i my workbook. I would like to use the
fraktile function on these data - how do I do??

=Fraktile(ventor;k)
if I type =Fraktile(AND(a2:a7;b2;b7);0,75) I dont get the right result.

I think I need to change "AND" but don't knoe to what?

/Jan
 
B

Bernard Liengme

This works for me: =PERCENTILE((G1:G21,F1:F21),0.75)
So you should try: =Fraktile((a2:a7;b2;b7);0,75)
best wishes from Canada
 
S

SirSimons

Perfect - thx



"Bernard Liengme" skrev:
This works for me: =PERCENTILE((G1:G21,F1:F21),0.75)
So you should try: =Fraktile((a2:a7;b2;b7);0,75)
best wishes from Canada
Click to expand...
 
Top