M
mistral
Have problem rouinding up result:
Some calculation, the worksheet last column contain the following formulas, from top to bottom:
=E17*F17
=E18*F18
=SUM(G17:G28) (subtotal)
=ROUND(IF(G30=0;G29;(1-G30/100)*G29);2)
=G29*0.18 (VAT)
=G31+G33 (Total)
Total show 709.99, I need get 710.00
Thanks.
Some calculation, the worksheet last column contain the following formulas, from top to bottom:
=E17*F17
=E18*F18
=SUM(G17:G28) (subtotal)
=ROUND(IF(G30=0;G29;(1-G30/100)*G29);2)
=G29*0.18 (VAT)
=G31+G33 (Total)
Total show 709.99, I need get 710.00
Thanks.