I am trying to calculate the 95th percentile of a subset of a data range. Column A is the hour of the day and column B is the data for each hour.
I can use this to calculate it successfully when there is only one parameter
{=PERCENTILE(IF($A$1:$A$100=1,$B$1:$B$100),0.95)}
but when I try for two parameters using this expression I only get #NUM! as my result.
{=PERCENTILE(IF((($A$1:$A$100=2)*($A$1:$A$100=1)),$B$1:$B$100),0.95)}
I can't figure out what is wrong with the 2nd expression.
Bookmarks