Excel round formula help? ?

Question

I would like to round the follwing example:

767,295 to be rounded as 767,000

606,815 to be rounded as 607,000

etc. Thanks!

Answer 1

Your data in column D. In cell E1 type the following

=IF(MOD(D1,1000)<=500,

FLOOR(D1,1000),CEILING(D1,1000))

all 1 line. Copy down as far as is needed. HTH

Answer 2

you would use the round() formula

your 767295 in cell A1

so B1 gets:

=ROUND(A1,-3)

the -3 says you want to round with 3 zeros

then just copy&paste down the B column.