Created attachment 113907 [details] calc file with incorrect results of multiplaying two columns I have a problem with Calc application because in the multiplication between the columns in the result gives a decimal number less than what is realistic and what is strange this numbers can not be obtained either by rounding multipliers, for example: in the program is 52.38 x = 3020.58 158,217.81 while the real result 158,217.98 perhaps it is the result of my poor adjustment programs if is that i pray for a solution because I do a lot of calculations
That's because the value of the cell is not 3020.58 but 3020.5768320. It has only been rounded to 2 decimal places for viewing only. If you want the price to be 3020.58 (which makes sense for money) then round the price to 2 decimal places "=ROUND(K47*$L$4*$M$1*E47;2)" for all cells.