Average Formula in Excel

The AVERAGE function is a built in function in MS Excel that calculates the average values in range of cell.

AVERAGE फ़ंक्शन MS Excel में एक अंतर्निहित फ़ंक्शन है जो सेल की श्रेणी में औसत मानों की गणना करता है।

Syntax: =average (A1, A2, A3, A4………..)

Exam:

=Average (3, 4, 5, 4) =4

=Average (4, 5, 4>3, 6) =4

=Average (4, 5, 2>3, 6) = 3.75

Average formula in Excel with Condition video: