Google-sheets – Unsimplified Fractions in Google Sheets

formulasgoogle sheetsgoogle-sheets-cell-format

How can I get Google Sheets to display fractions in the form I enter them, rather than in a simplified form? I'm trying to evaluate how a student did on a test, so I have one cell that reports the number of questions on the test (A1), another that has the number of questions answered correctly (B1), and a third that shows questions that the student ran out of time to answer (C1).

I've been trying to display this fraction as B1/(A1-C1), and I can get it as a fraction, but Sheets insists on simplifying it.

Best Answer

  • one of these may serve:

    =B2&"/"&(A2-C2)
    =B2&"/("&A2&"-"&C2&")"
    =TEXT(B2/(A2-C2), "#??/??")

enter image description here