T
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.
worksheet, but need rounded to 58 on another worksheet.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bill Kuunders
=ROUND(A1,-3)
C
CLR
=ROUND(A1,-3)
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3
C
clardy
to round this off, use =round(A1,-3) to round it off to 58000 where 57887 is
in A1
in A1
C
CLR
Sorry, misread.........maybe this
=ROUND(A1/1000,0)
Vaya con Dios,
Chuck, CABGx3
=ROUND(A1/1000,0)
Vaya con Dios,
Chuck, CABGx3
T
T. Valko
Try this:
Sheet1 A1 = 57,887
On sheet2:
=ROUND(Sheet1!A1,-3)
Result: 58,000
Sheet1 A1 = 57,887
On sheet2:
=ROUND(Sheet1!A1,-3)
Result: 58,000
R
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
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