Skip navigation

decimal places on numbers

1685 Views 7 Replies Latest reply: Apr 21, 2013 9:51 AM by Barry RSS
LavinaL Calculating status...
Currently Being Moderated
Apr 18, 2013 11:11 AM

I have calculated various percentages which give me more than two decimal places. I have kept the cells of these results at 2 decimal places. I have then used these various results and added them which have given me an error in the sum. I assume this is because the numbers I have added although seen as 2 decimal places have more than two decimal places. This means that my sum is various numbers off the right answer. How can I fix this problem?

 

Say 10.10 + 10.10 + 10.10 should SUM 30.30

 

But my answer comes to 30.29 as the 10.10 are not exactly 10.10 but as my cells are at 2 decimal places this is what I can see.

 

Hope I have explained myself.

 

 

Thanks for the help

MacBook Pro
  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Apr 18, 2013 11:20 AM (in response to LavinaL)

    If you have formatted the cells to display with 2 decimal places, this did not affect the underlying numbers. The actual numbers still have all their decimal places, you just don't see them.  Use the ROUND function if you want them to actually have two decimal places. Then they'll add up to what you want.

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Apr 19, 2013 12:18 AM (in response to LavinaL)

    Actually, the addition gave you the 'right' result, or more accurately, a closer approximation of the correct sum.

     

    Badunit has given you the method to obtain the less accurate, but 'expected' result.

     

    You will find ROUND in the same place as you can find every function supported in Numbers—in the Function Browser. Click the Function button (ellow, and labeled with an ƒ ) and choose Show Function Browser.

     

    In the browser, type 'rou' or as much more of the name to bring the function name into view. Select it and click Insert to insert it into the cell containing the insertion point.

     

    Regards,

    Barry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Apr 19, 2013 12:44 PM (in response to LavinaL)

    Best advice I can give to someone new to numbers (or new to spreadsheets in general) is to download and read at least the first four chapters of the Numbers '09 User Guide.

    If you're going to write formulas, you'll also want to have the iWork Formulas and Functions User Guide, which lists and describes all the functions supported in numbers, and gives at least one example of using each in a table.

    Both guides are available for download via the Help menu in Numbers.

     

    Regarding your current issue:

     

    Put your SUM() formula in the space labeled 'num-to-round' and the number of decimal places you want to have in the result in the space labeled 'digits'.

     

    Here's and example:

    Picture 3.png

     

    The formula in D2 is shown above the table.

    The three other cells in the column calculate the same sum, but round it to the nearer tenth, whole number, and hundred respectively. Formulas listed below:

     

    C4: =ROUND(SUM(B),1)

     

    C6: =ROUND(SUM(B),0)

     

    C8: =ROUND(SUM(B),-2)

     

    Regards,

    Barry

  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Apr 21, 2013 2:55 AM (in response to LavinaL)

    You need to use the ROUND function on the cells you are going to sum up. In your example, that would be the cells with the 10.10's in them.  You need them to actually be 10.10 before you sum them up, not 10.0967.  If you only round the sum, you will get the same result you are already getting, 30.29.

     

    Your formula will look like

    =ROUND(the formula that was in the cell before but without the equals sign, 2)

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Apr 21, 2013 9:51 AM (in response to Badunit)

    @ Badunit,

     

    Thanks for that correction. I was concentrating too closely on the syntax and lost sight of the details.

     

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.