rounding numbers

[Guest]

Is there a formula or way to have a number round up but show the even dollar
amount?

It's currently a 3 column worksheet - column a = 169.75 with the 2
consecutive columns each increasing 3% but I want the actual result to round
to the next whole dollar but show the 2 decimal points (170.00)

Can this be done - I'm self taught in excel

 

[BenjieLop]

Hi Lynn,

I am not sure if there is a more elegant formula but this is m
suggestion. Enter this formula in Cell B1 (with B1 formatted as
number to 2 decimal places):

=ceiling(A1,1)

which means that if cell A1 contains 169.75, cell B1 will show 170.0
(which is your desired result).

Hope this will help you.

 

[MikeY]

=CEILING(A1,2) for rounding up to the even amount

 

[Frank Kabel]

Hi
have a look at
http://www.xldynamic.com/source/xld.Rounding.html

 

[Guest]

There's also ROUND(A1,0) if you want it to round properly, or ROUNDUP(A1,0)
if you want to force it to round up. Both formatted to show 2 decimals