Calc can format cells as a fraction.
For instance in an empty cell input "=pi()" without the quotes. The cell
will display 3.141592654.
Then format the cell as FORMAT -> FRACTION -> FORMAT CODE -> and enter
???/??? which will change the display to 355/113. Is this what you need?
On 4/25/19 3:42 PM, James wrote:
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"
--
A smile - is a sign of joy.
A hug - is a sign of love.
A laugh - is a sign of happiness.
May your troubles be less...
May your blessings be more...
May nothing but happiness come through your door!!
Blessings, Joe Conner
Joshua 24:15 "...as for me and my house, we will serve the LORD."
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
Privacy Policy: http://www.documentfoundation.org/privacy
