Averaging data from a list between the nth percentiles

[ddc131]

How does the asterisk work in the below formula? I like the elegance, but I am scared to use it as I am unsure of the function.

Thanks

Relevant info from a prior post:

"=AVERAGE(IF((PERCENTRANK(A1:A10,A1:A10)>0.6)*(PERCENTRANK(A1:A10,A1:A10)<0.95),A1:A10))

Again array entered."

http://www.excelforum.com/excel-work...ml#post2298058

[shg]

On the left and right sight of the asterisk are logical expressions in parens. The asterisk is the ordinary multiplication operator.

When logical expressions are used in arithmetic operations, they are first coerced from True/False to 1/0 respectively, so the multiplication serves to AND the two expressions.

The parens are wrapped around the expressions to force the correct order of evaluation; see Operator Precedence in Help to understand why they are needed, or take them out and see how the expression evaluates without them.