ROUND CELLS TO NEAREST DOLLAR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
 
Using this formula =ROUNDUP(H38,0) returns $0.00 while the cell content is
$12.74 what am I doing wrong???
 
Hi
probably the cell is stored as 'Text'. What does the formula
=ISNUMBER(H38)
return?
 
Back
Top