On 17/07/17 1:38 PM, Davy Elias -davyintermedi...@gmail.com wrote:
Hi ,
I calculating number in column , but the result is different if we
calculate not with the formula
I calculate 354.84 x 13,320 the result is 4,726,468.80
but if we using 354.84 from formula
126.72+3.15- (+25%*126.72) + (2.5%* (25%*126.72)) result 98.9820
181.5 + 3.15 -(25%*181.5) +2.5%*(25%*126.72)) result is 140.4094
148.5 + 3.15 -(25%*148.5) +2.5% x(25%*148.5)) result is 115.4531
Then we sum 98.9820 +140.4094+115.4531 =354.8445
then we calculate the result 354.9885 * 13,320 the result is
_*4,726,528.74
*_
with calculator or I input the number single 354.84 x 13,320 =
4,726,468.80
Question : Why is different value ?
Your problem is that you display the calculated results with two
decimals while the real value has sometimes 3 or 4 decimals.
Calc use the real values and when you calculated the results manually
you enter them with 2 decimals as displayed.
You can see this if you change the cell format to display more decimals.
do you have solution for this ?
You are the solution, by changing the way you do the calculation.
If you want the results to be the same as you did manual then you need
to change your formulas e.g.
Change Cell G4 from *=+0.25*D4* to *=ROUND(+0.25*D4;2)**
*
Tks
Davy
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org