AVG
Return the mean of a range. A VisiGrid alias, not an Excel function.
Syntax
AVG(number1, [number2], ...)| Argument | Required | Description |
|---|---|---|
number1 | Required | A range or value to average. |
number2 | Optional | Further ranges or values. |
Examples
Every example below was executed against VisiGrid engine 0.31.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=AVG(A1:A5) | 20 | |
=AVERAGE(A1:A5) | 20 | Identical — AVG is an alias. |
Use AVERAGE instead
AVG behaves identically to AVERAGE here, but it does
not exist in Excel or Google Sheets. A workbook using it opens elsewhere with
#NAME? in every cell that referenced it.
Since the two are interchangeable in VisiGrid and only one is portable, there is
no reason to write AVG in anything you might share. It is documented because
it works — and because a formula you inherit might use it.
Excel compatibility
Not an Excel function. Excel returns #NAME? for AVG, so a file using it will not open correctly there.