Rounding numbers

  • Thread starter time conversion
  • Start date
T

time conversion

I have a large row of numbers that I need to round to the nearest 5, so I
used a formula of (=mround(A1:A3000,5) but this didn't work......anyone
have any ideas?
 
I

Infinitogool

Hi time
Try this formula in cell B1

=mround(A1,5)
Copy down as far as needed

Regards,
Pedro J.
 
T

time conversion

teethless....if the numbers are already in the row....what cell can I write
that formula in without that number disappearing?
 
Top