On 7/16/2017 11: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 ? > > do you have solution for this ? > > 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> > > > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > Davy;
Basically the problem is that 354.8445 and 354.84 are different numbers. To make the calculations in your spreadsheet match change the formula in I8 to =+I7*ROUNDDOWN(I6;2). What that does is round the value in I6 down 2 places thus matching the value j6. Regards Keith
signature.asc
Description: OpenPGP digital signature
