ROUND CELLS TO NEAREST DOLLAR

M

marc@ops2

I'm having trouble rounding the contents of the cells in a specific column to
the nearest dollar amount for product margins / markup. ie- $28.75 = $28.00.
All the "round" syntax or "dollar" result in everything but what I need, any
help possible???
Thanks Marc@ OPS2
 
R

Ron Rosenfeld

I'm having trouble rounding the contents of the cells in a specific column to
the nearest dollar amount for product margins / markup. ie- $28.75 = $28.00.
All the "round" syntax or "dollar" result in everything but what I need, any
help possible???
Thanks Marc@ OPS2

If you round 28.75 to the nearest dollar, the result should be 29.00, not
28.00.

=ROUND(28.75,0) will do that. Or, =ROUND(A1,0) if your value to be rounded is
in A1.

If you really want to ROUND DOWN as your example, and NOT round to the NEAREST
dollar, then use

=ROUNDDOWN(A1,0)


--ron
 
M

marc@ops2

Using this formula =ROUNDUP(H38,0) returns $0.00 while the cell content is
$12.74 what am I doing wrong???
 
F

Frank Kabel

Hi
probably the cell is stored as 'Text'. What does the formula
=ISNUMBER(H38)
return?
 

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