Fraktile function
 

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

Fraktile function
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SirSimons" wrote in message
...
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

Fraktile function
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SirSimons" wrote in message
...
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