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
Let's say we have an array of nubmers
How can we make them round up to



Excel's ceiling function can do this:
If 9333 were in A1, the formula 


If the numbers are in A1 to A4, place
in B1 and copy this formula down. This rounds to the nearest 500. Replace 499 by N1 and 500 by N to round to the nearest N. 

