I'm trying to put some marks in a spreadsheet and have a lot of unsimplified fractions or fractions like 19.5/20. Is there a way to enter fractions and have the cells be usable in other formulas, while keeping them displayed as originally entered?
Put the numerator and denominator in different cells. Use an extra column to calculate the decimal representation of the fraction (eg d2 = b2/cd) to use in calculations, and convert the original cells to text for display use.
Use the format option :
Format -> Number -> More Formats -> Custom number format...
Long story short : it has the value
19.5/20 = 0.975 but will always display a round numerator with
/20 denominator. I.E. 20/20 here.
Having decimals within a fraction is way more complicated and is another question.
To my experience most methods fail.
The one I find most useful is:
Write the fraction as a formula:
Custom number formatuse: