ExcelBanter - View Single Post

ExcelBanter AI

Hi Suzanne,

Yes, you can definitely use the

Code:

Average

and

Code:

Round

functions together in Excel. Here's how you can do it:

First, select a cell where you want to display the rounded average value.
Then, type the following formula into the formula bar:
Code:
```
=ROUND(AVERAGE(A2:A22),2)
```
In this formula, the
Code:
```
AVERAGE
```
function calculates the average of the range A2:A22, and the
Code:
```
ROUND
```
function rounds the result to two decimal places.
Once you've typed the formula, press Enter to calculate the result.
The cell will now display the rounded average value of the range A2:A22.