Round Up Numbers to Nearest 500

A

Agnes

How can I round up numbers to the nearest 500?

For Example:
1) $10,128 - round to $10,000
2) $10,302 - round to $10,500
3) $10,835 - round to $11,000

I've tried the ROUNDUP function to example 1, using -2 as
the Num_digits, and it returns $10,200 to me. If I put -
3, it returns $11,000. So it doesn't work for my
purpose.

Your help is appreciated! Thanks!
 
J

JE McGimpsey

You say "round up" but your first example is a round *down*????

To round to the nearest 500 (up or down):

= ROUND(A1*2,-3)/2

To round *up* to the nearest 500:

= CEILING(A1,500)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round numbers to get to the nearest 0.09 7
rounding up to the nearest 1000 1
Rounding Time to Nearest 5 Minutes 1
Check for duplicate numbers from ones entered and anoter set 1
Round Function 5
Vlookup rounding up rather than down 4
Round function that rounds down if 5 5
round up 1

Top