PERCENTILE with IF condition?

[ardnaxela]

I am trying to calculate percentiles using an if clause. For exI. want to calculate the 5th percentile weight for all of the women age 19. I am not sure how to write this formula out, also not sure what ctrl shift enter does for arrays? any help appreciated

 

[ardnaxela]

 

[ardnaxela]

https://imgur.com/a/d4OtFP5

Here is an example of the sheet I am using.

 

[steve the fish]

Something like:

=PERCENTILE.INC(IF(B1:B100=19,A1:A100),0.05)

with the weights in A1:A100 and the ages in B1:B100. CTRL-SHIFT-ENTER tells excel its dealing with an array rather than single cells. You must use it or you will get the wrong answer.

 

[ardnaxela]

This worked, thank you! Is there a way to modify this to be between two ages?

 

[steve the fish]

Add another IF:

=PERCENTILE.INC(IF(B1:B100>=19,IF(B1:B100<=25,A1:A100)),0.05)

 

[ardnaxela]

Much appreciated!