| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding numbers
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding numbers
=MROUND(A1,5)
copy down as far as needed "time conversion" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding numbers
Teethless...thanks....great!
"Teethless mama" wrote: =MROUND(A1,5) copy down as far as needed "time conversion" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding numbers
Hi time
Try this formula in cell B1 =mround(A1,5) Copy down as far as needed Regards, Pedro J. 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding numbers
teethless....if the numbers are already in the row....what cell can I write
that formula in without that number disappearing? "Teethless mama" wrote: =MROUND(A1,5) copy down as far as needed "time conversion" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding numbers
Are the numbers keyed in, or are they the returns of formulas?
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "time conversion" wrote in message ... teethless....if the numbers are already in the row....what cell can I write that formula in without that number disappearing? "Teethless mama" wrote: =MROUND(A1,5) copy down as far as needed "time conversion" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding numbers up or down | Excel Discussion (Misc queries) | |||
| numbers rounding | Excel Discussion (Misc queries) | |||
| Rounding numbers | Excel Discussion (Misc queries) | |||
| Rounding Numbers | Excel Discussion (Misc queries) | |||
| Rounding Numbers | Excel Worksheet Functions | |||
![time conversion[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
