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.
You might want to check out the ROUND worksheet function.
If A1 contains 2.15
=ROUND(A1, 1) equals 2.2
If A1 contains 2.149
=ROUND(A1, 1) equals 2.1
or
=ROUND(-1.475, 2) equals -1.48
=ROUND(21.5, -1) equals 20
hth
Vaya con Dios,
Chuck, CABGx3
quot;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.
全站熱搜
留言列表
