Nested IF Between Forumla help!

[adam9098]

Hello,

I am trying to pull data between specific dates and times. Below is my formula and I can't seem to get the formula to pull the data that is between.

=PERCENTILE(IF(TESTDATA!$A:$A="SERVERNAME",IF(AND(TESTDATA!$B:$B<=0+"6/4/2012 11:59:00 PM", TESTDATA!$B:$B>0+"6/1/2012 11:59:00 PM"),TESTDATA!$N:$N))), 0.95)

When I do the formula below I can get my results no problem, it's just getting in between the two dates that I am having issues.

=PERCENTILE(IF(TESTDATA!$A:$A="SERVERNAME",IF(TESTDATA!$B:$B<0+"6/1/2012 11:59:00 PM",TESTDATA!$N:$N)), 0.95)

Any ideas?

 

[AhoyNC]

I think the issue is having the array inside of the AND function.

This is untested but try (I may not have gotten all the parenthesis in the right place).

=PERCENTILE(IF(TESTDATA!$A:$A="SERVERNAME",IF((TESTDATA!$B:$B<=0+"6/4/2012 11:59:00 PM")*( TESTDATA!$B:$B>0+"6/1/2012 11:59:00 PM"),TESTDATA!$N:$N)), 0.95)

<COLGROUP><COL style="WIDTH: 821pt; mso-width-source: userset; mso-width-alt: 40045" width=1095><TBODY>
</TBODY>

Also since there is an array inside of an IF, I think you will probably need to enter this formula as an array using CTRL-SHIFT-ENTER.