next up previous contents index
Next: CAVG Up: A Function Reference Previous: ATANH

AVG

 

Syntax: @AVG(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

@AVG returns the average (arithmetic mean) of its arguments. Blank cells and strings are ignored. The function is given by:

displaymath15951

Examples:

@AVG(A1, B9, J32, F16) = 21.125, where A1 = 12, B9 = 34.5, J32 = 22, F16 = 16

@AVG(A1, A12..H13, 111+32) = 135.67, where we don't really care what is at those variables, but which shows that you can use numbers, ranges, and expressions all together as arguments for @AVG.


next up previous contents index
Next: CAVG Up: A Function Reference Previous: ATANH

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999