Skip navigation

(4.81 x £18.25) + (1.32 x £3.70) = £92.67... really?

335 Views 8 Replies Latest reply: Oct 23, 2012 10:44 PM by Barry RSS
Drieu Level 1 Level 1 (10 points)
Currently Being Moderated
Oct 23, 2012 7:22 AM

OK I know this comes up all the time in various ways but none of the answers I have seen so far actually tells you what to do. At least not in terms I can understand; they just use arcane language to say what you have done wrong. I am not a scientist or mathematician, I just want to do simple sums and get the right answer based on two decimal places. I get that the sums are processed with all the decimal places, even the ones you can't see, for reasons I have yet to fathom but nowhere can I find a way to simply round everything everywhere so I can push this stuff out to colleagues without looking like an idiot. Or at least not a numerically inept idiot :0)

 

Surely this should be a fundamental preference setting to make sure that people who need Numbers for basic stuff can use it with a level of accuracy. I have tried various ways of adding ROUND to a calculation and each one gives me red triangles. I have had to do today's work without any automated calculations (i.e. working it out by hand and then copying into the spreadsheet) and this has not been very easy. I would be grateul if someone could tell me how to configure things and how I can do this once, maybe for a template, and then forget about it.

 

I am now thinking about how many long and complex spreadsheets I have issued over recent years which I have trusted are correct and it is making me feel ill.

 

Thanks for reading.

 

Drew

  • Wayne Contello Level 6 Level 6 (12,640 points)

    Drew,

     

    I get that you are frustrated.  To round the displayed value in ALL cells, select the cell(s) you want to round and use the cells inspector to indicate the number of places to use when displaying the result.

     

    I am curious what you THINK the result should be?

     

    You did not indicate how many places you want to round to.

     

    You also did not provide an example of your use of ROUND() so we could review it-- we may be able to identify the problem.

     

    You also did not provide the error message that resulted.

     

     

    If you can provide the information above I am certain we can help.

     

    The Numbers application provides built-in help regarding all the functions.  To open the help (I use it all the time to remind myself) select the menu item "View > Show Function Browser", then use the search box at the top to type functions names.

     

    I hope this helps a little.

     


  • Wayne Contello Level 6 Level 6 (12,640 points)

    Drew,

     

    I don't think your expectation is correct.  Here is why:

     

    Screen Shot 2012-10-23 at 11.07.43 AM.png

    Screen Shot 2012-10-23 at 11.08.00 AM.png

    When you do not round anything ad multiply the numbers you provided that naturally result in more than 2 decimal places.  If you intend to round you INPUT data you should do that when you type in OR programatically when performing mathematical operations.  But you didn't round when you provided the input data.

     

    The inages above show the result when multiply and adding without modifying the displayed values from the actual values.

     

    92.6665 rounded to two places is: 92.97

     

    using the menu item "View > Show Function Browser" then type "ROUN" and the list of functions will be limited to those the start with that text:

     

    Screen Shot 2012-10-23 at 11.14.30 AM.png

     

    the function ROUND() takes two arguments (inputs):

    num-to-round and digits

     

    num-to-round is the number you want to round

     

    digits specifies how many decimal places you want the result to contain... 2 means two places FOLLOWING the decimal.

  • Wayne Contello Level 6 Level 6 (12,640 points)
    Currently Being Moderated
    Oct 23, 2012 10:42 AM (in response to Drieu)

    I think I would enter the data just like you have and add a new column that rounds the data correctly following the multiply:

    Screen Shot 2012-10-23 at 12.40.47 PM.png

     

    C2=ROUND(A2*B2, 2)

    select C2 and fill down

     

    C11=SUM(C)

  • Wayne Contello Level 6 Level 6 (12,640 points)
    Currently Being Moderated
    Oct 23, 2012 11:58 AM (in response to Drieu)

    Drew,

     

    ALL funtions have a name followed by a pair or parenthesis.  The parenthesis "contain" arguments (or function inputs).

     

     

    I would replace:

    =PRODUCT(C11:D11)

     

    with

    =ROUND(PRODUCT(C11:D11), 2)

     

    or

    =ROUND(C11*D11, 2)

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Oct 23, 2012 10:44 PM (in response to Drieu)

    Hi Drew,

     

    Wayne has covered you particular case well. These remarks apply to the general case.

     

    ROUND() works only on whatever you include inside its parentheses.

     

    In your case, you want to work with the rounded result of each multiplication, so you need to place the multiplication into ROUND's parentheses, and use one instance of ROUND for each multiplication.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (1)

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.