How to round up number in Excel

Question

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

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

Raystafarian · Accepted Answer · 2012-03-03 21:41:08Z

6

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

Raystafarian

20.8k10 gold badges58 silver badges90 bronze badges

answered Mar 2 '12 at 13:15

jdh

6,87514 silver badges21 bronze badges

Add a comment |

Tony Dallimore · Accepted Answer · 2012-03-02 12:09:59Z

1

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.

answered Mar 2 '12 at 12:09

Tony Dallimore

6964 silver badges12 bronze badges

Add a comment |

2 Answers 2