Hi :) I think the equation is unnecessarily over-complicated? Surely it should just be something like
K50 = Sum of the price of all products ? K51 = Round (Tax) ? Total to pay = K50 + K51 or maybe do an extra round just to make completely sure Total to pay = Round (K50 + K51) So, in Swedish K51 = HELTAL (Tax) ? Total to pay = HELTAL (K50 + K51) The trickiest bit should be the Tax calculation which is surely just Tax = K50 x Vat% Assuming none of the products is exempt from Vat or rated at a different Vat%! In England i think we have to truncate instead of Round. So K51 = AVKORTA ( K50 x Vat% ) but even if you do have to do that in Sweden the final figure should still be rounded Total to pay = Round (K50 + K51) Regards from Tom :) >________________________________ > From: Marino / WellnessWebshop.se <[email protected]> >To: [email protected] >Sent: Sunday, 14 July 2013, 8:11 >Subject: [libreoffice-users] Visible currency rounding > > >Hi! > >I want to have visible currency rounding on an invoice template that I have >made i Libre Office. I have this formula in the cell for currency rounding: > >=OM(HELTAL(K50+K51)-(K50+K51)>-0,5;AVKORTA(HELTAL(K50+K51)-(K50+K51);3);AVKORTA(HELTAL((K50+K51)+1)-(K50+K51);2)) > >But something is wrong, sometimes there is a diff of 0,01 in the sum. Perhaps >there is a better formula for this? > >My invoice looks like this, on the bottom rows: >- Sum for all products on invoice >- Tax >- Currency rounding >- Sum to pay > >Best regards, >Marino >-- >To unsubscribe e-mail to: [email protected] >Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >List archive: http://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be deleted > > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
