Versions Compared

Version Old Version 2 New Version Current
Changes made by

Migration

Nadica Gaber (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

The AVG and AVGR formulas Average and AverageRange formulas allow you to calculate the average of a number of values.

Syntax

AVG

CONTENT

Table of Contents

Average 

(Parameter0 + Parameter1 + Parameter2 + etc.)

The parameters are references to list items

of the parent list

.

Image Added

AVGR

AverageRange

(Parameter0:Parameter1) / # Parameters

Example

AVG

Image Removed

AVGR

Image Removed

Image Removed

CONTENT

toc

. This will calculate the average value of a range of items.

Image Added

Result

Image Added