2013 Archives by date, by thread · List index

# Re: [libreoffice-users] Visible currency rounding

```Hi :)
I think the equation is unnecessarily over-complicated?  Surely it should just be something like

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:
- 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
```