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
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityLet'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 =ceiling(a1,500)
would return 9500.
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.