rg
>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
At 09:11 14/07/2013 +0200, Marino Noname wrote:
I want to have visible currency rounding on an invoice template that
I have made in 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+K
= SHORTENING
Any new idea?
Kind regards,
Marino
-Ursprungligt meddelande-
From: Tom Davies
Sent: Sunday, July 14, 2013 11:02 AM
To: Marino / WellnessWebshop.se ; users@global.libreoffice.org
Subject: Re: [libreoffice-users] Visible currency rounding
Hi :)
Is AVKORTA = Truncate, ie just chopping
1)>-0,5;AVKORTA((HELTAL(K50+K51)-(K50+K51);3);(HELTAL((K50+K51)+1)-(K50+K51);2)))
ie, just move the truncate command outside of the calculation?
Regards from
Tom :)
>
> From: Marino / WellnessWebshop.se
>To: users@global.libreoffice.org
>
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,