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?

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?

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)

--

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)

--

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?