Using functions in OpenDocument (ods)

[cgbspender]

Hey,

Does anyone know how to use a percentage function or a sum function in OpenDocument ?

I did manage to make the sum function work... but, I could only make it work one line by one line. And I have more than 1000 entries, so I'd like something that will make the sums all at once.

For now it looks like this :

Code: Select all

              Column A      Column B        Column C            Column D (win ratio)
              Wins          Losses          Total of games

Player A       50              150            200                      25%
Player B

I don't have a D column yet. But I'd like one. How can I do it, so that it creates all the winratio for all players from player A to player Z, without having to re-write the same function again and again.
(and how to do with the "sum" function, in column C ?)

Thanks for the help.
edit : keep in mind, I'm really terrible at whatever uses numbers, let alone functions..
Cgb'

[LocoRon]

Hey,

Does anyone know how to use a percentage function or a sum function in OpenDocument ?

I did manage to make the sum function work... but, I could only make it work one line by one line. And I have more than 1000 entries, so I'd like something that will make the sums all at once.

For now it looks like this :

Code: Select all

              Column A      Column B        Column C            Column D (win ratio)
              Wins          Losses          Total of games

Player A       50              150            200                      25%
Player B

I don't have a D column yet. But I'd like one. How can I do it, so that it creates all the winratio for all players from player A to player Z, without having to re-write the same function again and again.
(and how to do with the "sum" function, in column C ?)

Thanks for the help.
edit : keep in mind, I'm really terrible at whatever uses numbers, let alone functions..
Cgb'

Ok, so first off I changed the structure a little bit to be like this:

Code: Select all

Column A       Column B      Column C        Column D            Column E (win ratio)
Player         Wins          Losses          Total of games

Player A       50              150            =SUM(B2:C2)        =SUM(B2/D2*100)%
Player B

Now you have to manually enter the wins and losses for each player, but you can easily replicate the formulas by highlighting those two cells, holding down the left mouse button on the black square in the lower right corner, and dragging it down as far as you want to go.

I've also attached a sample sheet you can work off of, if you want.

[cgbspender]

It seems it failed, or I did something wrong ?

[LocoRon]

It seems it failed, or I did something wrong ?

Change the D2 in the formula to E2.

Edit:

Also, change the ; to a /

[cgbspender]

errr, sure ?

[LocoRon]

errr, sure ?

=SOMME(C2/E2*100)%

[cgbspender]

hooray, worked perfect ! thanks for the help and for your patience !

[LocoRon]

hooray, worked perfect ! thanks for the help and for your patience !

Not a problem!