Computer average function formula
Function name：AVERAGE
Main functions:Find the arithmetic mean of all parameters.
Usage format:AVERAGE(number1,number2,……)
Parameter description:number1,number2,……: average value is required The value or reference cell (range), the number of parameters does not exceed 30.
Application example: Enter the formula in cell B8: =AVERAGE(B7:D7,F7:H7,7,8). After confirmation, you can find the area from B7 to D7 , the value in the area from F7 to H7 and the average value of 7 and 8.
Special reminder: If the reference range contains "0" value cells, they will be counted; if the reference range contains blank or character cells, they will not be counted.
Recommended tutorial:excel tutorial
The above is the detailed content of Computer average function formula. For more information, please follow other related articles on the PHP Chinese website!