ExcelBanter - Rounding

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rounding (https://www.excelbanter.com/excel-discussion-misc-queries/11591-rounding.html)

Christopher Anderson

Rounding

I have several numbers that are actually the result of several AVERAGE
functions. How would I round these numbers UP to the nearest 0.05?

Example:

34.66 to 34.70

32.23 to 32.25

etc.

Thanks in advance

Chris

JEV

=ROUND(AVERAGE(A1:A10),.05)

I think this will work.

"Christopher Anderson" wrote:

I have several numbers that are actually the result of several AVERAGE
functions. How would I round these numbers UP to the nearest 0.05?

Example:

34.66 to 34.70

32.23 to 32.25

etc.

Thanks in advance

Chris

Hi

Try
=CEILING(A1,0.05)

--
Andy.

"Christopher Anderson" wrote
in message ...
I have several numbers that are actually the result of several AVERAGE
functions. How would I round these numbers UP to the nearest 0.05?

Example:

34.66 to 34.70

32.23 to 32.25

etc.

Thanks in advance

Chris

All times are GMT +1. The time now is 04:45 PM.