Rounding to the nearest 5
If I have 100 different numbers, that will be very time consuming - unless I
am missing something. Is there a function that will recognize any number
and decide that it should be rounded to the nearest 5?
"bpeltzer" wrote:
rmound should do it (eg =mround(63,5) )
"Lisa" wrote:
I need to round a group of numbers to the nearest 5...like 63 would be 65, 68
would be 70, 51 would be 50, etc. Is there a formula for this?
|