WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS

[Guest]

I'M USING MSEXCEL 2003 AND WOULD LIKE TO KNOW WHAT SYNTAX TO USE IN A FORMULA
FOR THE FOLLOWING EXAMPLE:

THE SYNTAX WOULD CONVERT UP AND DOWN A 4 DIGIT WHOLE NUMBER TO THE NEAREST
THOUSANDS:

4600 WILL EQUAL 5000
4300 WILL EQUAL 4000

 

[Myrna Larson]

=ROUND(A1/1000,0)*1000

Or look at the MROUND function in Help.

 

[Biff]

Hi!

try this:

=ROUND(A1/1000,0)*1000

Biff

 

[Sandy Mann]

Why not simply

=ROUND(A1,-3)

Regards

Sandy

 

[Myrna Larson]

Yes, that will work, too, but the idea of negative number of decimal places
has always seemed strange to me <g>.