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.

=ROUND(A1,-3)

--
Greetings from New Zealand

"tps1234" wrote in message
...
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.

=ROUND(A1,-3)

Vaya con Dios,
Chuck, CABGx3




"tps1234" wrote:

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.

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

=ROUND(A1/1000,0)

Vaya con Dios,
Chuck, CABGx3





"CLR" wrote:


=ROUND(A1,-3)

Vaya con Dios,
Chuck, CABGx3




"tps1234" wrote:

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.

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



"tps1234" wrote:

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.

Try this:

Sheet1 A1 = 57,887

On sheet2:

=ROUND(Sheet1!A1,-3)

Result: 58,000

--
Biff
Microsoft Excel MVP


"tps1234" wrote in message
...
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.

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


"tps1234" wrote in message
...
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.