HighAvg returns the highest value averaged over n-years from an array of values. Zero values are ignored.
Syntax
HighAvg (Compensation,
NumberInAvg, Consecutive)
|
Parameter Name |
Description |
|
Compensation |
Array
of values to be used in the average calculation (e.g. salary history over an
employee’s career): named range; or reference to a range; or multiple values
delimited with semi colons. |
|
NumberInAvg |
Number of periods to be
used in the average calculation. |
|
Consecutive |
TRUE
to use consecutive years in the average calculation; otherwise use
non-consecutive years. |
Related Topics