PDA

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).