# Thread: nearest 1000

1. ## nearest 1000

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

2. ## Re: nearest 1000

Try this:

<pre>=ROUND(ValueOrCellToRound,-3)</pre>

3. ## Re: nearest 1000

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

4. ## Re: nearest 1000

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

5. ## Re: nearest 1000

ok, just rounding up is:

<pre>=ROUNDUP(ValueOrCellToRound,-3)</pre>

6. ## Re: nearest 1000

Thanks so much - I was desperate. That works

7. ## Re: nearest 1000

Sorry but did not see your revised requirement

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

AC

8. ## Re: nearest 1000

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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•