Den lör 27 apr. 2019 kl 13:29 skrev Johnny Rosenberg <[email protected] >:
> > > Den fre 26 apr. 2019 kl 23:09 skrev Luuk <[email protected]>: > >> 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 < >> [email protected] >> >> : >> >> Den fre 26 apr. 2019 kl 20:37 skrev Luuk <[email protected]>: >> >> >> >>> 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: [email protected] >> >>> 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: [email protected] >> 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: [email protected] 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
