close
I am trying to round in my spreedsheet, I have the cell rounding to 2 if it
is 1.13, my dilemma is if the cell is 9.03 it rounds to 10 and I want to know
how (if its possible) to keep it 9?
=IF(A1-INT(A1)gt;=0.13,ROUNDUP(A1,0),ROUND(A1,0))
Vaya con Dios,
Chuck, CABGx3quot;cld5044quot; wrote:
gt; I am trying to round in my spreedsheet, I have the cell rounding to 2 if it
gt; is 1.13, my dilemma is if the cell is 9.03 it rounds to 10 and I want to know
gt; how (if its possible) to keep it 9?
gt;
全站熱搜
留言列表
