round cells in column to nearest dollar value

[marc@ops2]

I need to round the cell contents of a given column to the nearest dollar.
any help would be greatly appreciated. I not sure if a formula can be created
to round the values .00 = < or > than .5 round to the nearest X.00
Marc

 

[Ramakrishnan Rajamani]

Try the round function. It might work.

 

[kkknie]

Not sure exactly what you meant, but using ROUND, ROUNDUP or ROUNDDOWN
should do the trick.

K

 

[marc@ops2]

,here is the problem the cell content is $12.74 now using the =ROUNDUP(H38,0)
returns $0.00 ? looking at the formula menu it shows $13.00 but when applied
it returns $0.... when I evaluate the formula I get "0,0" ?? What I really
need is to round the contents of each cell in a column to the nearest dollar
value. is there a way to do this or would it require a cell by cell approach?
Thanks for the help

 

[Ron Rosenfeld]

,here is the problem the cell content is $12.74 now using the =ROUNDUP(H38,0)
returns $0.00 ? looking at the formula menu it shows $13.00 but when applied
it returns $0.... when I evaluate the formula I get "0,0" ?? What I really
need is to round the contents of each cell in a column to the nearest dollar
value. is there a way to do this or would it require a cell by cell approach?
Thanks for the help

It is likely that the $12.74 is text and not a number.

What is the formula in the cell that is displaying $12.74?


--ron

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.Rounding.html