Can Excel do this?

[farmerjohn1324]

Is there a formula in MS Excel where you can round to the nearest 1000.

For example, I have a cell that has the formula SUM(J1:J4) and it currently equals 23,893.

I want to make another cell that rounds this up to 24,000.

I have tried ROUNDUP and ROUND, but unless I am using them wrong, they don't work for what I am trying to do.

 

[strollin]

If the Sum(J1:J4) is in cell J10, then in another cell: =ROUND((J10*0.001),0)*1000

You first need to convert to a decimal, then Round, then convert back by multiplying by 1000. ROUND will round up or down, whichever is closest, ROUNDUP will always round up.

 

[salvage-this]

Try this nested function. the -3 rounds to the 3rd zero in.

=ROUND(SUM(J1:J4),-3)