Den lör 27 apr. 2019 kl 13:29 skrev Johnny Rosenberg <

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 <

>>

[hidden email]
>> >> :

>> >> Den fre 26 apr. 2019 kl 20:37 skrev Luuk <

[hidden email]>:

>> >>

>> >>> 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:

[hidden email]
>> >>> 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:

[hidden email]
>> 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>>

>