Re: [libreoffice-users] Visible currency rounding

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 <marino@wellnesswebshop.se>
> To: users@global.libreoffice.org 
> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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