What is AVG and how is it used in ms excel? [Archive]

View Full Version : What is AVG and how is it used in ms excel?

wedd

10-19-2010, 07:35 AM

Hi, can an excel expert explain to me what is AVG and how it is used?

Thanks:friends:

Ago

10-19-2010, 09:35 AM

Average?

A1=0
A2=10
A3=Avg(A1:A2) '5

A1=5
A2=10
A3=Avg(A1:A2) '7.5

Sum of range devided by number of entrys

Bob Phillips

10-20-2010, 12:49 AM

Ever tried looking at Help?

Kenneth Hobs

10-20-2010, 05:03 AM

In Excel, =AVG(somerange) after pressing the Enter key and saying Yes will correct it to =AVERAGE(somerange). Help will first show the AVERAGE function.

AVG in other spreadsheet programs like Lotus123 and QuattroPro means the @AVG(somerange).