Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Let's say we have an array of nubmers

 $9,333.00 
 $5,733.00 
 $21,333.00 
 $21,833.00 

How can we make them round up to

 $9,500.00 
 $6,000.00 
 $25,500.00 
 $22,000.00 
share|improve this question
2  
I assume example 3 is a typo. 21,333 rounds to 25,000, should that be 21,500? – barry houdini Mar 2 '12 at 15:23
    
I agree here with @barryhoudini, I don't think the data you have is possible – Raystafarian Mar 2 '12 at 19:39
    
@barryhoudini Yes thank you. I've fixed it. – Nam G VU Mar 5 '12 at 7:48
up vote 6 down vote accepted

Excel's ceiling function can do this: If 9333 were in A1, the formula =ceiling(a1,500) would return 9500.

share|improve this answer

If the numbers are in A1 to A4, place

=INT((A1+499)/500)*500

in B1 and copy this formula down.

This rounds to the nearest 500. Replace 499 by N-1 and 500 by N to round to the nearest N.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .