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 |
Make divisions and display no decimal value at the quotient!
Hello,
take =INT(A1/A2) HTH, Bernd |
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