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
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
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?
I'm using LO V6.2.2.2 (x64) to prepare documents which use graphics
generated in LO Draw. The graphics are annotated screenshots taken with
Snagit which is then grouped and copied into the doccuments. The
graphics have a caption figure .. which is placed below the image.
See the example