jeffmlucas
New member
- Joined
- Jan 18, 2017
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hello,
I need some help with calculating percentiles while using an array formula. Current formula is:
=IF(B7:B15>6,PERCENTILE(IF(Data!$G:$G=ReportPages!A1,IF(Data!$E:$E=ReportPages!A7:A15,IF(Data!$I:$I>0,Data!$I:$I))),0.1),"*")
ENTER +CTRL + SHIFT
The return value is #N/A
I isolated the issue to the "ReportPages!A7:A15" portion of the formula. It works fine with I change this to reference a single cell. Any help would be great.
Thanks,
Jeff
I need some help with calculating percentiles while using an array formula. Current formula is:
=IF(B7:B15>6,PERCENTILE(IF(Data!$G:$G=ReportPages!A1,IF(Data!$E:$E=ReportPages!A7:A15,IF(Data!$I:$I>0,Data!$I:$I))),0.1),"*")
ENTER +CTRL + SHIFT
The return value is #N/A
I isolated the issue to the "ReportPages!A7:A15" portion of the formula. It works fine with I change this to reference a single cell. Any help would be great.
Thanks,
Jeff