Fraktile function

[Guest]

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

 

[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

 

[Guest]

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