On 14-07-2013 09:11, Marino / WellnessWebshop.se wrote:
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))
http://goo.gl/CM2Sf
= IF (INT (K50 + K51) - (K50 + K51)> -0.5; TRUNC (INT (K50 + K51) - (K50
+ K51), 3); TRUNC (INT ((K50 + K51) +1 ) - (K50 + K51), 2))
I only had to add some space to the original function (before and after
OM, HELTAL and AVKORTA)
--
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
