round cells in column to nearest dollar value

M

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
 
K

kkknie

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

K
 
M

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top