close

I would like to know how to make divisions and print the result without
decimals in Excel. I know I can change the format of the cell so it
doesnt display decimals, but that's not what I want. In first, because
it rounds-off the number!

Thanks in advance!--
FreakyShadow
------------------------------------------------------------------------
FreakyShadow's Profile: www.excelforum.com/member.php...oamp;userid=32154
View this thread: www.excelforum.com/showthread...hreadid=519059Hello,

take
=INT(A1/A2)

HTH,
BerndWrote:
gt; Hello,
gt;
gt; take
gt; =INT(A1/A2)
gt;
gt; HTH,
gt; Bernd

Thanks for the response! But I found easier to truncate the quotient of
the division!

-FreakyShadow--
FreakyShadow
------------------------------------------------------------------------
FreakyShadow's Profile: www.excelforum.com/member.php...oamp;userid=32154
View this thread: www.excelforum.com/showthread...hreadid=519059

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()