I have to add some amounts that are percentages of other amounts. I have set them to display only two decimals, and I want the total to be calculated using the amounts on display. But it's adding the actual values of the percentages so I get this:
What do I have to do so that the sum displayed shows £86.40 instead?
Mac mini, macOS 10.15
You have to make the result of the formula producing the '£21.60' displayed equal to the displayed value.
Setting the display to show only two places after the decimal rounds the display, but does not change the actual value in the cell. If these cell contain entered values, shorten the entry to include only two places after the decimal.
Numbers automatically rounds the display to the number of places after the decimal set for the cell, but that rounding does not change the actual value in the cell. To do that, you need to wrp the formula creating that value with ROUND, and specify that the rounding is to the nearest hundredth.
ROUND(yourformula,2)
in each cell of the left column should do the job.
Regards,
Barry
You have to make the result of the formula producing the '£21.60' displayed equal to the displayed value.
Setting the display to show only two places after the decimal rounds the display, but does not change the actual value in the cell. If these cell contain entered values, shorten the entry to include only two places after the decimal.
Numbers automatically rounds the display to the number of places after the decimal set for the cell, but that rounding does not change the actual value in the cell. To do that, you need to wrp the formula creating that value with ROUND, and specify that the rounding is to the nearest hundredth.
ROUND(yourformula,2)
in each cell of the left column should do the job.
Regards,
Barry
I wanted to add: I thought I had solved the problem when I found the custom cell formatting function. I tried creating a custom cell format... but whatever I do, it always displays only one decimal and I cannot change that.
"I thought I had solved the problem when I found the custom cell formatting function"
"Formatting" of any sort changes how a number is displayed, but does not change the actual value of the number underlying that display.
Regards,
Barry
Thank you, that is exactly what I needed.
Decimals and adding percentages.
