I'm dividing the value in one cell by a value in another cell. I want the final result to be in fraction form and not reduce to the smallest equivalent fraction.
I've figured out how to get the result of the
=divide to format in fraction form
However, I cannot find a way to keep Google Sheets from simplifying it.
=DIVIDE(O4,M10) in my sheet should show
20/80 - but it converts to
I want to see
20/80. The denominator will change, so I can't do this
It also cannot be formatted as text, because this fraction needs to be used in future math operations.