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

=ROUND(A1/1000,0)*1000

Or look at the MROUND function in Help.

On Fri, 18 Feb 2005 20:37:05 -0800, KENITOSAN
wrote:

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

Why not simply

=ROUND(A1,-3)

Regards

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Myrna Larson" wrote in message
...
=ROUND(A1/1000,0)*1000

Or look at the MROUND function in Help.

On Fri, 18 Feb 2005 20:37:05 -0800, KENITOSAN
wrote:

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

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

On Sat, 19 Feb 2005 15:58:01 -0000, "Sandy Mann"
wrote:

Why not simply

=ROUND(A1,-3)

Regards

Sandy

Hi!

try this:

=ROUND(A1/1000,0)*1000

Biff

-----Original Message-----
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
.