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

Wayne Contello Austin, Texas
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 builtin 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.

Like (0)


Drieu Scotland
Hi Wayne, thanks for your speedy reply to my peevish question.
I think the answer to the question should be £92.66. In that the calculation resolves to £87.78 + £4.88.
I know how to set the number of decimal places in the cell inspector and in the tool bar but I am told this only applies to what is shown, not what Numbers considers in a calculation. I have three columns. One gives the area in metres to two decimal places, the next give the rate per metre, to two decimal places and the third shows the totals. So what it looks like is:
4.81 18.25 87.78
1.32 3.70 4.88
92.67
I understand that, if I were doing this purely, to three decimal places, it would look different but I had naively thought, before researching here, that I would get a true value for the decimal places as displayed.
I want to round to two decimal places. This is fairly universal in the calculations I am doing so I would have liked that to be the default.
I did not provide an example of my attempted ROUND usage because I was convinced I was entering it in the wrong place or entering something illegal. I tried to deduce from other answers how one manipulated functions like this, as well as spending a lot of time with Help and I am still no wiser. I used the insert button in the browser but that got me the same red triangles. I suppose I could spend a day on tutorials and it might be well spent but, as you know, when issues come up they tend to do so when working to a deadline etc.
If someone could perhaps point me to the bit in help which covers how to input function information like ROUND or ROUNDUP for cells which already contain the product of a calculation I would be in their debt.
If someone knows someone at Apple who is working hard on making a preference for the next release of Numbers which will hit this problem on the head I would be delighted to know. I am not holding my breath though and I expect someone may tell me how easy it is to do what I need to do and then I will never look back again.
Still frustrated, Drew

Like (0)


Wayne Contello Austin, Texas
Drew,
I don't think your expectation is correct. Here is why:
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:
the function ROUND() takes two arguments (inputs):
numtoround and digits
numtoround 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.

Like (0)


Drieu Scotland
Hi again.
I do understand how this works with a calculation which generates more than two decimal places. Obviously the answer is going to be different. However this cannot work with calculating costs using standard currency expressions, so the two decimal places have to be immutable for the sum to work in an accounting sense.
I hear what you are saying about the need to input rounded data but the data did not need rounded until the calculation had taken place, which added another digit after the decimal place. I set all the cells to default to two decimal places but I understand this is meaningless as far as a calculation is concerned.
If, to enter all the data which I know is going to be part of calculation, which may or may not force another decimal place, I have to write it by using the Function browser I will surely go mad. Is there a way to apply the same function requirement to a whole column or row, either before entering the numbers or after?
Thanks for your time.
Drew

Like (0)


Wayne Contello Austin, Texas

Like (0)


Drieu Scotland
That is great, seeing how it is supposed to go together. I got it to work on a cell by cell basis but cannot get a fill down to work; it puts zeros in all the empty cells and wipes the numbers which are in there on their own, not as the result of a calculation.
When I have =PRODUCT(C11:D11), for example, how should ROUND be introduced in the sequence. I tried and failed.
If I set the whole table to be  ROUND,2  , will other auto functions just resolve automatically when applied to certain cells in the table do you know? I am thinking about simplifying input.
Sorry to go on.
Cheers
Drew

Like (0)


Wayne Contello Austin, Texas
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)

Like (0)


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

Like (0)
