Someone else can hopefully answer your question, but what I can tell you is
that you don't need the + signs. A Excel formula starts with =, not with
=+. The + is a relic from old Lotus spreadsheets.
--
David Biddulph

"Idoia" wrote in message
...
I need to calculate a percentile, but my data is not organized as one
single
array, but in 2 ranges.

I've tried things like:
=+PERCENTILE({A1:A4,D8:D11},0.9)
=+PERCENTILE({A1:A4;D8:D11},0.9)
=+PERCENTILE(A1:A4&D8:D11,0.9)
={+PERCENTILE(A1:A4&D8:D11,0.9)}

Nothing seems to work... Any ideas?

Thanks