Re: [libreoffice-users] percent to whole fraction

Yes, Calc.

It works well enough using format code "# ??/200".
I guess I can use /200 for all of them but I was hoping for a formula 
that would pick the lowest denominator.

Thanks.


On 2019-04-25 6:45 p.m., 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