| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell to the nearest 100
Is there a format for rounding a cell to the nearest 100 so that 501.35
rounds to 500. I was using #,##0 to just round to the dollar, but I want to got to the nearest 100. Any thoughts? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell to the nearest 100
Gandor: Try =ROUND(A1,-2) where A1 is the number you want to round.
"Gandor" wrote: Is there a format for rounding a cell to the nearest 100 so that 501.35 rounds to 500. I was using #,##0 to just round to the dollar, but I want to got to the nearest 100. Any thoughts? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell to the nearest 100
Gandor wrote:
Is there a format for rounding a cell to the nearest 100 so that 501.35 rounds to 500. I was using #,##0 to just round to the dollar, but I want to got to the nearest 100. Any thoughts? IN Excel 2007 =ROUNDDOWN(B3,-2) -- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell to the nearest 100
*Nearest*, so ROUND, not ROUNDDOWN.
-- David Biddulph "Chris Premo" wrote in message ... Gandor wrote: Is there a format for rounding a cell to the nearest 100 so that 501.35 rounds to 500. I was using #,##0 to just round to the dollar, but I want to got to the nearest 100. Any thoughts? IN Excel 2007 =ROUNDDOWN(B3,-2) -- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell to the nearest 100
Thanks for the suggestions. I was hoping for a format versus a formula. But
this will do "TKS_Mark" wrote: Gandor: Try =ROUND(A1,-2) where A1 is the number you want to round. "Gandor" wrote: Is there a format for rounding a cell to the nearest 100 so that 501.35 rounds to 500. I was using #,##0 to just round to the dollar, but I want to got to the nearest 100. Any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round a number to the nearest .49 in a cell that has a fo | Excel Worksheet Functions | |||
| How to search for nearest nonblank cell in previous rows? | Excel Discussion (Misc queries) | |||
| Format number cells to the nearest 1,000 | Excel Discussion (Misc queries) | |||
| Format Round to Nearest Thousand | Excel Discussion (Misc queries) | |||
| How do I format cells to round to the nearest thousands without .. | Excel Discussion (Misc queries) | |||
Linear Mode
