ROUND CELLS TO NEAREST DOLLAR

[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

 

[Frank Kabel]

Hi
either use
=ROUND(A1,0)
or
=ROUNDUP(A1,0)

 

[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

 

[marc@ops2]

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

 

[Frank Kabel]

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