I have a problem with a basic math formula in Excel please help?

Question

I have a problem in excel i wrote a basic adding formula to sum 2 cells and then multiply the sum of them by 9 but the program keeps ignoring the small decimals which at the end makes a huge difference in my calculation, for example: =((J10+P10)*9), thats the formula and J10=12.55 and P10=6.02 and the answer is supposed to b 167.13 but the the program gave me 167.10 as the answer which is off by .03 wut should i do?

Answer 1

go to format cell
and change the decimal places to 3 or more
that will help .13 is rounded to .10
good luck

Answer 2

As you describe it, your problem is not related to the number of decimal places. If the formula you've described is giving you the answer you indicated there is another problem. First check your data by increasing the number of displayed decimal places to see if there's a rounding problem, i.e. the numbers are not actually what you're seeing.

If this is not the problem there could be something else wrong but I'd have to have more info.

Answer 3

You don't need all those parentheses.

=(J10+P10)*9, Check your formatting in all the related cells. Your format is rounding down to .10

Answer 4

Select the cells you want.

Select Format --> Cells

In the 'Number' tab, select 'Number'. Change 'Decimal Places' to 4 (or 5 or whatever you want).

Click OK.

Should be working now. You have to do this to all of the cells you are adding and summing and multiplying.

Answer 5

check the decimal placing right click the cell and go to format cells, and under number you can choose how many decimal places should be displayed

Answer 6

Your code should look like this =9*(j10+p10) not =((J10+P10)*9) and if your getting 167.10 then that's because your totals are not right but if it is right it should look like this 167.1 theres no .10 and to fix this just format and number then put 2 decimals.