Returning sum as part of a fraction

[bethie4rmb]

This may not be possible.

I have a spreadsheet that has three rows and three columns each row will be assigned a 1, 2 or 3 for a possible total of 9. In the end they need to be added. What I want is a formula that will return this as a fraction.

Like this: 7/9

Can anyone help please??

Thanks!

 

[Jonmo1]

You could do

=SUM(A1:A3)/9

Format the cell with the formula as Fraction.

 

[bethie4rmb]

I tried the formula. It works great if the fraction is something like 7/9 however if it is 9/9 it changes to 1, no matter what the cell is formatted as.

Any other suggestions??? Thank you all so much!

 

[edvwvw]

=TEXT(SUM(A1:A3),0)&"/9"

edvwvw

 

[bethie4rmb]

edvwvw ~ It works! Thank you so much!

jonmo1 ~ Thanks for helping out also!

Have a great day!!

 

[Andrew Poulsom]

You can also format the cell as ?/9.

 

[bethie4rmb]

Andrew ~ thank you also!

I was wondering if any of you could help me with one more thing.

The same formula 7/9 needs to convert to a % depending on the fraction. In particular:
3-5 = 0% 6-7 = .5% 8-9 = 1%. The fraction is in one cell and the converted percentage is in in the cell directly beside it.

Thanks!

 

[Andrew Poulsom]

Try eg:

=LOOKUP(SUM(A1:A3),{0,6,8},{0,0.005,0.01})

 

[bethie4rmb]

Woohoo!!! It works like a charm, my life is officially 63 times easier!!
Thank you so much!!!!