In my older version of excel, I didn't have this problem, so I'm chalking it up to some settings that I am having a hard time finding. I have Excel 2007. Essentially, I have been trying to create an excel spreadsheet that will compute range combinatorics for poker and I am unable to stop the cells from rounding off to the nearest whole number. I want to see numbers to the thousandth. What am I doing wrong? Thanks.
-
-
Here is an example. I have set up cell C so that it "=QUOTIENT(B1,A1)," where zero it is giving me zero, instead of 0.01357....Comment -
[delurk]
First solution: select the cells that you want to change. Use the "increase decimal" toolbar button to display as many decimal places as you wish.
Second solution: In the "format cells" menu option, use the number tab to set your decimal places.
[lurk]Comment -
Thanks Mad, I have tried the increase decimal option in the toolbar and nothing. I will try your second solution. Thanks for trying to help me.Comment -
IDK, looks like he already has it set to the correct number of decimals, but it's still rounding. I'd play with it some, but I have 2010 office I believe.Comment -
yah...nothing is working! Hate 2007 everything.Comment -
The QUOTIENT function is supposed to return 0 when using the numbers you show. Per definition, it returns the whole number from a division, without the remainder. So anytime you divide a number with a larger number, QUOTIENT will return 0. If you want it to return 18/1326 with decimals, then the formula should just be =B1/A1. I assume I am missing something here.Comment -
But what does "/" represent in your "18/1326?" aren't we still finding the quotient, where 18 is the numerator and 1326 is the denominator?Comment -
And yes, Excel 2007 does suck badly. I highly recommend upgrading to 2010. 2010 has fewer issues/bug (at least for the stuff I do) and is considerably faster when processing.Comment -
If you want to divide the value of a cell by another you just write it like I did, i.e. =B1/A1. "/" is the sign used for regular division in Excel, just like "+" is used for addition, "-" for subtraction etc. QUOTIENT is a function, just like SUM, AVERAGE, MEDIAN are functions. The QUOTIENT function is written to return just the whole number.Comment -
k...going to give it a go.Comment -
hahaha....that was too easy. I have always looked up the functions beforehand. Thanks.Comment -
You're welcome. Glad you got it to work.Comment
