Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

So basically I am trying to find a way to show a simple ratio of wins vs total games.

for example:

  • 2 wins on 5 games would give me a ratio of 2:5
  • 5 wins on 15 games: 1:3
  • 8 wins on 18 games: 4:9

As a nice to have, it would fun to allow half points for the first member, but I guess this would be too complicated:

  • 7 wins on 10 games: 3.5:5

Thanks

share|improve this question
    
To avoid decimal points, you can multiply by 10; 7 wins on 10 games: 35:50 –  Jacob Jan Tuinstra Feb 22 '13 at 13:12

1 Answer 1

up vote 1 down vote accepted

I see that you want to simplify the fraction (e.g. 5/15 => 1/3), but there's no standard function for that in Google Spreadsheets.

Some time ago I found this post, where a formula is mentioned:

=(A2*(10^(LEN(A2)-2)))/GCD(A2*(10^(LEN(A2)-2)) ;10^(LEN(A2)-2))& " / " & ( 10^(LEN(A2)-2)) /GCD(A2*(10^(LEN(A2)-2)) ;10^(LEN(A2)-2))

where A2 is wins divided by games. It does not grant your wish of half points, but you might be able to massage the formula into giving you that.

I set up an example spreadsheet using that formula here.

share|improve this answer
    
Wow totally a.w.e.s.o.m.e Much more complicated than what I expected. Thanks so much. –  Guillaume Bois Feb 22 '13 at 15:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.