Rounding

[Christopher Anderson]

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.

 

[Guest]

Hi

Try
=CEILING(A1,0.05)