Round Numbers and Dosplay Zeros

Ken · Oct 17, 2003

Using Excel 2000 and cell A1 containing the number
7,418,212, what is the formula in B1 that will return
7,418,000 in B2? Or with 7,418,545 in A1, it would return
7,419,000.
TIA.

Dale Hymel · Oct 17, 2003

=ROUND(A1,-3)

Biff · Oct 17, 2003

Hi Ken,

Try:

=ROUND(A1,-3)

Biff

Laura · Oct 17, 2003

Divide by 1000, round, and then multiply by 1000 again.

Round Numbers and Dosplay Zeros

Ken

Dale Hymel

Biff

Laura