array calculation and percentile

Originally Posted by amulee

hi ianbec
I think you may use + (or) instead of * (and)
Try this formula
{=PERCENTILE(IF((($A$1:$A$100=2)+($A$1:$A$100=1)),$B$1:$B$100),0.95)}

Brilliant - works perfectly - Thankyou.