Forum Discussion
working on double elimination bracket need help with formula
To achieve this without using a hidden cell, you can use nested IF statements combined with IFERROR function to check the conditions and fill the cells accordingly.
Here is how you can set up the formulas:
In cell D9:
=IFERROR(IF(C8=2,C8,IF(C10=2,C10,"")),"")
In cell B77:
=IF(D9=C8,C10,IF(D9=C10,C8,""))
Here is how these formulas work:
- In cell D9, the formula checks if C8 equals 2, if true, it fills D9 with the value of C8. If not, it checks if C10 equals 2, if true, it fills D9 with the value of C10. If neither condition is met, it leaves D9 blank.
- In cell B77, the formula checks if D9 equals C8. If true, it fills B77 with the value of C10. If not, it checks if D9 equals C10. If true, it fills B77 with the value of C8. If neither condition is met, it leaves B77 blank.
These formulas should dynamically update based on the values in cells C8 and C10, without the need for an extra hidden cell. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
I didn't get much that made sense following the instructions! It seems D9 will contain 2 (presumably match points?) either way, and B77 will contain the opposite result. The sort of thing I would go for is
E9 (round1Winner)
= IFS(team1=2, team1info, team2=2, team2info, 1, "")
B77 (round2team1)
= round1winnerbut, probably, that merely shows that I have failed to understand the requirements.
