Re: [libreoffice-users] percent to whole fraction

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