How do I round numbers derived from an average formula?
Within a cell I am using the average formula and I get decimals. How can I round the number derived?
One option is to put the Average function in parenthesis inside the Round function (following examples rounds to 0 decimal places:
=ROUND(AVERAGE(B2:B5),0)
The other option would be to format the cell to the number of decimals you want to display.