Skip to main content
Web Applications

Return to Question

Tweeted twitter.com/StackWebApps/status/971966243686117378
edited tags
Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297
fixing typos
Source Link
edit approved Mar 8, 2018 at 21:48
arieljannai
edit approved Mar 8, 2018 at 21:48
arieljannai
  • 3.9k
  • 4
  • 24
  • 61

I'm dividing the value in one cell by a value in another cell. II want tothe final result to be in fraction form and not reduce to the smallest equivalent fraction. I've
I've figured out how to get the result of the =divide=divide to format in fraction form (# ???/???)(# ???/???). However
However, I cannot find a way to keep Google Sheets from simplifying it.

For example:For example:
=DIVIDE(O4,M10)=DIVIDE(O4,M10) in my sheet should show 20/80-20/80 - but it converts to 1/41/4. I
I want to see 20/8020/80. TheThe denominator will change, so I can't do this # ??/80# ??/80.

It also cannot be formatted as text, because this fraction needs to be used in future math operations.

Tips?

I'm dividing the value in one cell by a value in another cell. I want to 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.

For example: =DIVIDE(O4,M10) in my sheet should show 20/80-- but it converts to 1/4. I want to see 20/80. The denominator will change, so I can't do this # ??/80.

It also cannot be formatted as text, because this fraction needs to be used in future math operations.

Tips?

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.

For example:
=DIVIDE(O4,M10) in my sheet should show 20/80 - but it converts to 1/4.
I want to see 20/80. The denominator will change, so I can't do this # ??/80.

It also cannot be formatted as text, because this fraction needs to be used in future math operations.

Tips?

Source Link
Amanda Dawn Fischetti
Amanda Dawn Fischetti
  • 45
  • 1
  • 5

Formatting the results of =divide as a fraction without being simplified (google sheets)

I'm dividing the value in one cell by a value in another cell. I want to 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.

For example: =DIVIDE(O4,M10) in my sheet should show 20/80-- but it converts to 1/4. I want to see 20/80. The denominator will change, so I can't do this # ??/80.

It also cannot be formatted as text, because this fraction needs to be used in future math operations.

Tips?