Thread: Format cell to the nearest 100
View Single Post
  #3  
Old December 15th, 2008, 10:18 PM posted to microsoft.public.excel.misc
Chris Premo
external usenet poster
  
Posts: 39
Default 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)

--