Hello..
I am trying to figure out the 90% of a range to response times, if both Z42 and Z58 are true.. I have came up with these two formulas but I keep getting a "You've entered to many arguments for this function".
=PERCENTILE.EXC((IF(AND($C$2:$C$278=$Z$42,if($E$2:$E$278=$Z$58),$O$2:$O$278)),0.9)))
=PERCENTILE.EXC((IF($C$2:$C$278=$Z$42,AND($E$2:$E$278=$Z$58),"",$O$2:$O$278)),0.9)))
Any help is always greatly appreciated.
I am trying to figure out the 90% of a range to response times, if both Z42 and Z58 are true.. I have came up with these two formulas but I keep getting a "You've entered to many arguments for this function".
=PERCENTILE.EXC((IF(AND($C$2:$C$278=$Z$42,if($E$2:$E$278=$Z$58),$O$2:$O$278)),0.9)))
=PERCENTILE.EXC((IF($C$2:$C$278=$Z$42,AND($E$2:$E$278=$Z$58),"",$O$2:$O$278)),0.9)))
Any help is always greatly appreciated.