When are they used: AVERAGE :- You use the AVERAGE function in Excel to return the average (arithmetic mean) of the specified cells. Example 1. Calculating an average of numbers To find out an average of certain numbers, you can supply them directly in your Excel average formula.For example, =AVERAGE(1,3,4) returns 2.67 as the result. AVERAGEIF :- The classical […]