|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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
|