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+unsubscr...@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
