Forum Discussion

Jannesu8's avatar
Jannesu8
Copper Contributor
Jun 13, 2023

Formula point system 40 team tournament

Anyone who can help me out with a formula using lots of 'IF CONDITIONS'?   I am currently making a sheat for a tournament with 40 teams who are divided over 8 groups (5 teams/group) and the point s...
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 14, 2023

Jannesu8 

To modify your formula to only count matches with filled-in scores, you can add an additional condition to check if the scores are not blank.

Here's an updated version of your formula that includes this condition:

=IF(NOT(ISBLANK(M4)), IF(M4<Q4, "+3", IF(M4>Q4, "+0", "+1")), 0) + IF(NOT(ISBLANK(Q7)), IF(Q7<M7, "+3", IF(Q7>M7, "+0", "+1")), 0) + IF(NOT(ISBLANK(M10)), IF(M10>Q10, "+3", IF(M10<Q10, "+0", "+1")), 0) + IF(NOT(ISBLANK(M13)), IF(M13>Q13, "+3", IF(M13<Q13, "+0", "+1")), 0)

This formula checks if the scores in cells M4, Q7, M10, and M13 are not blank using the ISBLANK function. If a score is not blank, it applies the respective points calculation based on the comparison with the opposing team's score. If a score is blank, it returns 0.

Make sure to adjust the cell references in the formula based on the actual location of your scores.

I hope this helps!

Resources