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.