How to retain one decimal place for average function in excel table

Recently, when many friends are calculating the average, they find that some values ​​are not divisible. If they are not divisible, you can choose to retain the number of decimal places. For example, one or two decimal places are acceptable, but many friends do not. If you know how to set it through the average function, let me introduce it to you. Setting method 1. First, we select a cell to calculate the average.

2. Then find the average value in the formula.

3. Then we select A1:E1, and then press Enter to get the result.

4. Then click to set the cell format.

5. Finally, you can set the number of decimal places in the numerical interface. It is very convenient. One or two decimal places are acceptable.

The above is the detailed content of How to retain one decimal place for average function in excel table. For more information, please follow other related articles on the PHP Chinese website!