ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make divisions and display no decimal value at the quotient! (https://www.excelbanter.com/excel-discussion-misc-queries/75311-make-divisions-display-no-decimal-value-quotient.html)

FreakyShadow

Make divisions and display no decimal value at the quotient!
 

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: http://www.excelforum.com/member.php...o&userid=32154
View this thread: http://www.excelforum.com/showthread...hreadid=519059


[email protected]

Make divisions and display no decimal value at the quotient!
 
Hello,

take
=INT(A1/A2)

HTH,
Bernd


FreakyShadow

Make divisions and display no decimal value at the quotient!
 

Wrote:
Hello,

take
=INT(A1/A2)

HTH,
Bernd


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

-FreakyShadow


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



All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com