nearest 1000

Topic

New Reply

I have a formula and want the cell to round up to the nearest 1000. For example, Cell A1 + B7 – if the number is 2694 I want it to round to 3000. Any ideas? Thanks

Reply | Quote

Replies

Try this:

=ROUND(ValueOrCellToRound,-3)

Reply | Quote

Close but it rounds down. I need it to round up instead of nearest 1000. Sorry for the mixup. any ideas?

Reply | Quote

ok, just rounding up is:

=ROUNDUP(ValueOrCellToRound,-3)

Reply | Quote

Thanks so much – I was desperate. That works

Reply | Quote

If you start Excel Help, Index, and enter “rounding numbers” (lower case) and doubleclick it, you’ll find Excel has all kinds of rounding capabilities.

Reply | Quote

Sorry but did not see your revised requirement

the following should do it ROUNDUP(A1,-3)

AC

Reply | Quote

The following will round a value in A1 to the nearest 1000

=MROUND(A1,1000)

Changing the 1000 to 100 rounds to the nearest 100 etc

Regards,

Andrew C

Reply | Quote