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 :



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'

_________________
Staying true to myself.

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



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.

It seems it failed, or I did something wrong ?

_________________
Staying true to myself.

Change the D2 in the formula to E2.

Edit:

Also, change the ; to a /

errr, sure ?

_________________
Staying true to myself.

=SOMME(C2/E2*100)%

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

_________________
Staying true to myself.

Not a problem!