Rounding (Already) Whole Numbers

[H7H12]

Hi there,

I have an Excel question you guys can hopefully help me solve...

Essentially, I have the following number:

1967

And I would like to round it up to 2000. As the number has no decimal places, I've already exhausted the decrease decimal tool in Excel 2007. Is there an easy way to round numbers like this up to certain amounts?

I am using Excel 2007, with Windows XP. Happy to provide more information if necessary.

 

[pagrender]

How about this:

this rounds to the nearest thousand:
=ROUND(A1,-3)

This rounds up to the nearest thousand:
=CEILING(A1,1000)

 

[VoG]

Try

=CEILING(A1,1000)

 

[H7H12]

These are both fantastic - thanks very much (I love this board!)

 

[H7H12]

Actually, I have one more quick query regarding the 'round' one...

The cell I'll be rounding up has a calculation in it. Is there any way I can do the calculation, then consequently round the amount up, in the same cell?

 

[VoG]

Try
=CEILING(your formula,1000)

 

[H7H12]

Perfect - thanks!