1. 04-19-12 02:28 PM #1
    High3rEl3m3nt
    SBR's 7 figure Contractor
    High3rEl3m3nt's Avatar Become A Pro!
    Join Date: 09-28-10
    Posts: 8,004
    Betpoints: 4134

    Need excel help

    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.
    Reply With Quote Reply With Quote
  2. 04-19-12 02:41 PM #2
    High3rEl3m3nt
    SBR's 7 figure Contractor
    High3rEl3m3nt's Avatar Become A Pro!
    Join Date: 09-28-10
    Posts: 8,004
    Betpoints: 4134

    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....
    Last edited by SBRAdmin3; 06-09-14 at 05:51 PM. Reason: Link Not Working - Removed-)
    Reply With Quote Reply With Quote
  3. 04-19-12 03:03 PM #3
    MadTiger
    Wait 'til next year!
    MadTiger's Avatar Become A Pro!
    Join Date: 04-19-09
    Posts: 2,724
    Betpoints: 47

    [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]
    Points Awarded:

    High3rEl3m3nt gave MadTiger 2 SBR Point(s) for this post.

    Reply With Quote Reply With Quote
  4. 04-19-12 03:13 PM #4
    High3rEl3m3nt
    SBR's 7 figure Contractor
    High3rEl3m3nt's Avatar Become A Pro!
    Join Date: 09-28-10
    Posts: 8,004
    Betpoints: 4134

    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.
    Reply With Quote Reply With Quote
  5. 04-19-12 03:32 PM #5
    CrazyCarl
    CrazyCarl's Avatar Become A Pro!
    Join Date: 10-09-11
    Posts: 1,437
    Betpoints: 2162

    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.
    Reply With Quote Reply With Quote
  6. 04-19-12 03:41 PM #6
    High3rEl3m3nt
    SBR's 7 figure Contractor
    High3rEl3m3nt's Avatar Become A Pro!
    Join Date: 09-28-10
    Posts: 8,004
    Betpoints: 4134

    yah...nothing is working! Hate 2007 everything.
    Reply With Quote Reply With Quote
  7. 04-19-12 03:56 PM #7
    thom321
    thom321's Avatar Become A Pro!
    Join Date: 06-17-11
    Posts: 112
    Betpoints: 4983

    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.
    Reply With Quote Reply With Quote
  8. 04-19-12 04:13 PM #8
    High3rEl3m3nt
    SBR's 7 figure Contractor
    High3rEl3m3nt's Avatar Become A Pro!
    Join Date: 09-28-10
    Posts: 8,004
    Betpoints: 4134

    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?
    Reply With Quote Reply With Quote
  9. 04-19-12 04:15 PM #9
    thom321
    thom321's Avatar Become A Pro!
    Join Date: 06-17-11
    Posts: 112
    Betpoints: 4983

    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.
    Reply With Quote Reply With Quote
  10. 04-19-12 04:27 PM #10
    thom321
    thom321's Avatar Become A Pro!
    Join Date: 06-17-11
    Posts: 112
    Betpoints: 4983

    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.
    Nomination(s):
    This post was nominated 1 time . To view the nominated thread please click here. People who nominated: High3rEl3m3nt
    Reply With Quote Reply With Quote 1
  11. 04-19-12 04:28 PM #11
    High3rEl3m3nt
    SBR's 7 figure Contractor
    High3rEl3m3nt's Avatar Become A Pro!
    Join Date: 09-28-10
    Posts: 8,004
    Betpoints: 4134

    k...going to give it a go.
    Reply With Quote Reply With Quote
  12. 04-19-12 04:29 PM #12
    High3rEl3m3nt
    SBR's 7 figure Contractor
    High3rEl3m3nt's Avatar Become A Pro!
    Join Date: 09-28-10
    Posts: 8,004
    Betpoints: 4134

    hahaha....that was too easy. I have always looked up the functions beforehand. Thanks.
    Reply With Quote Reply With Quote
  13. 04-19-12 04:34 PM #13
    thom321
    thom321's Avatar Become A Pro!
    Join Date: 06-17-11
    Posts: 112
    Betpoints: 4983

    You're welcome. Glad you got it to work.
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »