I have an Excel sheet where i am multiplying 4 cell, with one cell containing a formula. But the result is wrong.
The formula is A1*B1*D1*E1. In the first row the cell D1 value has been entered manually. D1 is actually C1/1000.
In the 6th row the the cell D6 is calculated using =C6/1000. But as you can see the results F1 AND F6 are different. F1 gives 100.67925. and F6 gives 100.41255. The correct answer is actually F1 =100.67925.
All the cells are in number format and no rounding has been done.I dont know what i am doing wrong. Please give a solution to my problem. Thank you.
SOLVED
I found out the problem. As Máté Juhász and elserra pointed out it was due to rounding problem. The rounding problem occurred because i changed the number format from General to Number. I again went and typed 1.51 in to D1 and hence the result in F1 was obtained. I didnt check the actual value for D1 in the formula bar. i was checking rounding by changing the decimal value places. Thank you for your solution.
41 Answer
When having troubles like this, first try with easy numbers so you can follow the steps, for example 2 , 4 , 10... If you grab a calculator, you will see that 3 x 2.5 x 1506 / 1000 x 8.89 = 100.41255. If you do the same with 3 x 2.5 x 1.51 x 8.89 you will get 100.67925.
This means you're doing it right and Excel is also calculating everything correct. Look if the source telling you that 100.41255 is wrong may be incorrect. As @Mate points out, this source may be rounding the value for D1.
