close
On our pricing sheet, we want to round up if the last number of a two decimal
place 5 or more and round down if less than 5 per cell. I know a if
statement should do it, but have not been able to complete one.
I think you should be able to do this with a simple ROUND() function...
=ROUND(A1,1)
For example, This will turn 45.85 into 45.90 and 45.84 into 45.80. Is this
what you wanted?
--
Regards,
Davequot;ddquot; wrote:
gt; On our pricing sheet, we want to round up if the last number of a two decimal
gt; place 5 or more and round down if less than 5 per cell. I know a if
gt; statement should do it, but have not been able to complete one.
全站熱搜
留言列表
