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 community
Excel's ceiling function can do this:
If 9333 were in A1, the formula
=ceiling(a1,500) would return 9500.