Re: [libreoffice-users] percent to whole fraction

Den lör 27 apr. 2019 kl 13:29 skrev Johnny Rosenberg <gurus.knugum@gmail.com
> :

> Den fre 26 apr. 2019 kl 23:09 skrev Luuk <luuk34@gmail.com>:
>
> > YES, LCM() that's the function i was looking for...
> >
> > I did not know it that function exists, probably because it's name in my
> > Dutch version of EXCEL is KGV()..... :-[
>
> It's named ”MGM()” in my Swedish version (Minsta Gemensamma Multipel).

I didn't pay attention that you wrote ”EXCEL”, I was still talking about
LibreOffice Calc. Sorry for the confusion.


> Do you know that you can easily pick another language for the graphical
> user interface? You need to restart LibreOffice, and then all cell
> functions are in the selected language (English would be a good choice in
> this case). I usually do that when I'm about to ask or reply to questions
> on this mailing lists, if I need to copy and paste cell formulas or explain
> how to find a certain thing in the menues. Nobody will understand
> ”≈OM(ÄRTAL(LETARAD(blah;blah;blah));1;0)”, for instance.
> Also, do you know that you can hit Ctrl+F2 for help when creating cell
> formulas? I dialogue will pop up helping you to find what you need and you
> can look through cell functions by category and more. You can also see the
> results of parts of your formula, making it easier to debug a faulty
> formula. I found it very helpful and there's where I found the LCM()
> function (although it was called MGM when I found it).
>
>
> Kind regards
>
> Johnny Rosenberg
>
>
>
> > (see:
> >
> > https://www.excel-function-translation.com/index.php?page=english-dutch.html
> > )
> >
> >
> > On 26-4-2019 22:54, Johnny Rosenberg wrote:
> > > Den fre 26 apr. 2019 kl 22:42 skrev Johnny Rosenberg <
> > gurus.knugum@gmail.com
> > > > :
> > > > Den fre 26 apr. 2019 kl 20:37 skrev Luuk <luuk34@gmail.com>:
> > > >
> > > > > Let me rephrase the question.... ;)
> > > > >
> > > > > In the 'example' line we see:
> > > > >
> > > > > 56  302    28/151
> > > > >
> > > > > The actual cell contents are:
> > > > >
> > > > > 56 302     0,18543046357615894039735099337748
> > > > >
> > > > > Is it possible to get the values '28' and '151' as show by the
> > > > > fraction-formatter?
> > > > Are we allowed to use the first two numbers (56 and 302 in this case)
> > or
> > > > only the fraction (0,185…)?
> > > > Are we allowed to create our own cell functions?
> > > > Is the maximum values 999/999 or are higher numbers allowed?
> > > > Do you want one number (28) in one cell and the other number (151) in
> > > > another cell or what?
> > > If you can use the original numbers (56 and 302 in the example above),
> > > here's a short example:
> > > A1=56
> > > B1=302
> > > C1=LCM(A1;B1)/B1 ⇨ 28
> > > D1=LCM(A1;B1)/A1 ⇨ 151
> > >
> > > Kind regards
> > >
> > > Johnny Rosenberg
> > >
> > >
> > > > Kind regards
> > > >
> > > > Johnny Rosenberg
> > > >
> > > >
> > > >
> > > > > On 26-4-2019 19:01, Luuk wrote:
> > > > > > Is there an option to convert a cell with format 'Fraction' to text?
> > > > > >
> > > > > > example:
> > > > > >
> > > > > > a     b       'a/b
> > > > > >
> > > > > > 52    297     52/297
> > > > > > 56    302     28/151
> > > > > > 66    311     66/311
> > > > > >
> > > > > > in this third line, i want to get '28' and '151'....
> > > > > >
> > > > > > i tried TEXT(C2;""), and FIND("/";C2;1),
> > > > > >
> > > > > >
> > > > > > On 26-4-2019 00:45, Remy Gauthier wrote:
> > > > > > > Hi,
> > > > > > >
> > > > > > > I am assuming you are using Calc. There is no formula to do this:
> > it is
> > > > > > > a cell formatting accessible via Format -> Cells... -> Numbers Tab,
> > > > > > > then go to the "Fraction" category. There you can select the #
> > ???/???
> > > > > > > format which will do what you are looking for.
> > > > > > >
> > > > > > > I hope this helps.
> > > > > > >
> > > > > > > R??my.
> > > > > > > Le jeudi 25 avril 2019 ?? 21:42 +0000, James a ??crit :
> > > > > > > > I need a formula that takes as input a percent and outputs a
> > fraction
> > > > > > > > that only has whole numbers.
> > > > > > > > Eg.
> > > > > > > > 1% -> "1/100"
> > > > > > > > 0.5% -> "1/200"
> > > > > > > > 1.5% -> "3/200"
> > > > > --
> > > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > > > Posting guidelines + more:
> > https://wiki.documentfoundation.org/Netiquette
> > > > > List archive: https://listarchives.libreoffice.org/global/users/
> > > > > Privacy Policy: https://www.documentfoundation.org/privacy
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy