rounding

[tps1234]

How do I round a number to the nearest thousand (i.e. 57,887 pulled from one
worksheet, but need rounded to 58 on another worksheet.

 

[Bill Kuunders]

=ROUND(A1,-3)

 

[CLR]

=ROUND(A1,-3)

Vaya con Dios,
Chuck, CABGx3

 

[clardy]

to round this off, use =round(A1,-3) to round it off to 58000 where 57887 is
in A1

 

[CLR]

Sorry, misread.........maybe this

=ROUND(A1/1000,0)

Vaya con Dios,
Chuck, CABGx3

 

[T. Valko]

Try this:

Sheet1 A1 = 57,887

On sheet2:

=ROUND(Sheet1!A1,-3)

Result: 58,000

 

[Rick Rothstein \(MVP - VB\)]

If you want the value actually rounded, you could use the ROUND function as
others have posted. However, if you want to display it rounded, but wish to
keep the original value (perhaps for subsequent calculation purposes), you
could put a normal reference to the original cell so the that 57,887 is
placed in the cell and then Custom Format the cell using 0, (a zero followed
by a comma) for the custom pattern.

Rick