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>
calculating.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org