| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
How can I round a number by editing the cell format?
For example, 17551 to 17550 16284 to 16280 22135 to 22140 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
Try the below
=IF(MOD(A1,10)4,CEILING(A1,10),FLOOR(A1,10)) If this post helps click Yes --------------- Jacob Skaria "Crystal Lee" wrote: How can I round a number by editing the cell format? For example, 17551 to 17550 16284 to 16280 22135 to 22140 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
You can also use MROUND() which returns a number rounded to the desired
multiple. =MROUND(A1,10) If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in...menu ToolsAdd-Ins check Analysis ToolPak If this post helps click Yes --------------- Jacob Skaria "Crystal Lee" wrote: How can I round a number by editing the cell format? For example, 17551 to 17550 16284 to 16280 22135 to 22140 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
Thanks for your reply. But is it possible to do the same thing by edit the
cell format (ie without adding formula)? "Jacob Skaria" wrote: You can also use MROUND() which returns a number rounded to the desired multiple. =MROUND(A1,10) If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in...menu ToolsAdd-Ins check Analysis ToolPak If this post helps click Yes --------------- Jacob Skaria "Crystal Lee" wrote: How can I round a number by editing the cell format? For example, 17551 to 17550 16284 to 16280 22135 to 22140 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
=ROUND(A1,-1)
Can't be done with format. -- David Biddulph "Crystal Lee" wrote in message ... How can I round a number by editing the cell format? For example, 17551 to 17550 16284 to 16280 22135 to 22140 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
thanks for your help~
"David Biddulph" wrote: =ROUND(A1,-1) Can't be done with format. -- David Biddulph "Crystal Lee" wrote in message ... How can I round a number by editing the cell format? For example, 17551 to 17550 16284 to 16280 22135 to 22140 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
Cannot..
If this post helps click Yes --------------- Jacob Skaria "Crystal Lee" wrote: Thanks for your reply. But is it possible to do the same thing by edit the cell format (ie without adding formula)? "Jacob Skaria" wrote: You can also use MROUND() which returns a number rounded to the desired multiple. =MROUND(A1,10) If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in...menu ToolsAdd-Ins check Analysis ToolPak If this post helps click Yes --------------- Jacob Skaria "Crystal Lee" wrote: How can I round a number by editing the cell format? For example, 17551 to 17550 16284 to 16280 22135 to 22140 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Rounding Up | Excel Worksheet Functions | |||
| Rounding | Excel Discussion (Misc queries) | |||
![Crystal Lee[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
