How to calculate average in excel with two decimal places

To find the average in Excel and keep two decimal places, you can use the function ROUND(): select the range of cells containing data. Enter the formula in the formula bar: =ROUND(AVERAGE(cell range), 2). Press Enter to calculate the average to two decimal places.

Use Excel to find the average and keep two decimal places

In Excel, you can use the function ROUND() to find the average and round to two decimal places.

Steps:

1. Select the range of data cells containing the data to be calculated.

2. In the formula bar, enter the following formula:

   <code>=ROUND(AVERAGE(单元格区域), 2)</code>

   For example: to calculate the average value in the cell range A1:A10 and retain two decimal places, the formula is:

   <code>=ROUND(AVERAGE(A1:A10), 2)</code>

3. Press the Enter key.

Example:

Assume that the cell range A1:A10 contains the following data:

##A110A212A314A416A518A620A722A824A926A10#28

cell Cell	Value

Use the formula

=ROUND(AVERAGE(A1:A10), 2), The average value to two decimal places can be calculated as:

<code>=ROUND(AVERAGE(A1:A10), 2)
=ROUND(18, 2)
=18.00</code>

The above is the detailed content of How to calculate average in excel with two decimal places. For more information, please follow other related articles on the PHP Chinese website!