Round to nearest 5?

C

Confused Man

Hello all,

I have a lot of data and I want to have it all round to the nearest "5"....
so that weather it is a whole number or one with a decimal it always
contains the same number of digits but always ends in either 0 or 5.

For example:
10371.80 stays the same
1204.98 rounds to 1205.00
696.51 rounds to 696.50
etc.

Thank you all,
Confused Man
 
D

Dave Peterson

Maybe...

=ROUND(A1*20,0)/20

If you mean you want to round to the nearest "nickel".
 
E

Earl Kiosterud

Man,

=ROUND(A2/5,2)*5

This works with your examples, but I'm not sure it satisfies your
description in all weather.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
VBA multiple list of values for variable 1
rounding up to nearest specified whole number 1
Rounding Time to Nearest 5 Minutes 1
Currency and Rounding 0
Label alignment of XY-plot, center is a bit off. Any ideas? 0
Rounding down nearest 00 7
I need to always Round UP if greater than zero at all. HOW? 9

Top