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
