If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|