Use the avg function to return the average value of two or more Integer / Decimal values, or values that make up a Collection.

Function format

avg(Input value)

  • Input value: accepts Integer / Decimal values, or a Collection. Value added to the other value(s) and divided by the total number of values to find the average.

avg example

avg(1, 2, 3, 4, 5)

The formula returns the Integer value 3.