Format cell to the nearest 100

G

Gandor

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?
 
C

Chris Premo

Gandor said:
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?
Click to expand...

IN Excel 2007

=ROUNDDOWN(B3,-2)

--
 
G

Gandor

Thanks for the suggestions. I was hoping for a format versus a formula. But
this will do
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Varied accuracy custom number formats 3
rounding up to nearest specified whole number 1
Round formula 1
Round Down to the nearest multiple 2
Round-Up question 2
Rounding by .05 4
Average rounded to nearest 0.50 4
Rounding to the nearest 50 cents 4

Top