I have values in Col “A” and “B” and a win-lost column in “C” and “D”.
I’m trying to figure out how automatically fill in column “C” and “D” correctly based on the values in col “A” and “B” for team 1.
Is there an “easy” way to do this (and how)? Thanks ahead for any suggestions and help.
Total for Col “C” and “D”.ods (16.2 KB)
Can you get draws in this competition? If you can, then you would need a third column
Earnest, No if there is a tie, they keep playing til one wins.
C3 is IF(A3-B3>0,1,0)
D3 is IF(A3-B3<0,1,0)
C4 is IF(A3-B3>0,1,0) + C3
etc …
Total for Col C and _D_120951.ods|attachment (18.7 KB)
Thanks to both PKG and fpy for the solution. I could understand “fpy” answer a little (a lot) better is why I give him the solution.
But both works just fine. Thanks again in helping me.
much shorter formulas when using logical TRUE/FALSE
000_count gradually TEAM 1 winnings_122259.ods (25.8 KB)
no solution found in =MATRiX{} area in adding each upper value
Genau, but (slightly) less pedagogical considering the OP 
you could also go with lost = row() - 2 - win 
etc …