Percentile...IF

**brook1** · 11-16-2006, 05:10 AM

Help...

I would like to use the percentile function on column B, for example,dependant upon the entry on column A.

e.g. So if A = Red the percentile (B:B,0.95)

What would the formula for this be?

Thanks
Michelle

**davesexcel** · 11-16-2006, 06:20 AM

Percentile( array, nth_percentile )

A1 = percentile (B:B,0.95)

**starguy** · 11-16-2006, 06:23 AM

Originally Posted by brook1

Help...

I would like to use the percentile function on column B, for example,dependant upon the entry on column A.

e.g. So if A = Red the percentile (B:B,0.95)

What would the formula for this be?

Thanks
Michelle

not very clear, following formula might solve your problem

=IF(A1="Red",PERCENTILE(B:B,0.95),"")

Regards.