[libreoffice-users] Re: a little math problem with Calc

Am 05.07.2012 11:43, Andreas Säger wrote:
> E1: input value
> A1: =INT($E1)
> B1: =$E1-$A1
> C1: =$B1*100
> D1: =INT($C1)
>
> This is how it works in all spreadsheet applications. It applies to any
> other row where you copy the formulas to.
> You may even save this simple calculation in xls(x) format and it will
> work in Excel.


Stupid me!
That is in one formula:
=INT(($E1-INT($E1))*100)
or even
=MOD($E1;1)*100
Isn't it?


--
For unsubscribe instructions e-mail to: users+help@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