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
- Jun 04 Wed 2008 20:44
Make divisions and display no decimal value at the quotient!
close
全站熱搜
留言列表
發表留言
留言列表

