| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Burgh Man Wrote: I wish to have the numbers rounded to the nearest 10 (or nearest 100 or nearest 1000. (Ex.) 1069.06 I wish to have rounded NOT to 1069 but to 1070 (the nearest 10). I can't seem to find the fix for this. Please help. Use =MROUND(1069.06,10) this should round up to =1070 -- El_Melenero ------------------------------------------------------------------------ El_Melenero's Profile: http://www.hightechtalks.com/m344 View this thread: http://www.hightechtalks.com/t767020 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Linear Mode
