Re: [libreoffice-users] percent to whole fraction

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+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