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