Return the sum of the highest 3 values in Column H (rng_h).
The Percentile function returns the nth percentile from a set of values.
The syntax for the Percentile function is:
Percentile( array, nth_percentile )
array is a range or array from which you want to return the nth percentile.
nth_percentile is the percentile value. It can be a value between 0 and 1.
Return the average of the highest 3 values in Column H (rng_h), rounding it to one digit.
The Percentile function returns the nth percentile from a set of values.
The syntax for the Percentile function is:
Percentile( array, nth_percentile )
array is a range or array from which you want to return the nth percentile.
nth_percentile is the percentile value. It can be a value between 0 and 1.
