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
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 N-1 and 500 by N to round to the nearest N.