Forum Discussion
working on double elimination bracket need help with formula
have cell b8 with team 1
cell b10 with team 2
if cell c8 has a 2 need to fill cell d9 with cell c8 info
or if cell c10 has a 2 need to fill cell d9 with cell c10 info
if neither has a 2 need to have cell d9 blank.
if cell d9 has cell c8 info want cell b77 filled with cell c10 info or
if cell d9 has cell c10 info want cell b77 filled with cell c10 info
any help or ideas have had it figured out if i put a hidden cell with an extra formula trying to not have that.
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.
- NikolinoDEGold Contributor
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.
- PeterBartholomew1Silver Contributor
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) = round1winner
but, probably, that merely shows that I have failed to understand the requirements.
- nathanaelgjones1018Copper Contributorso the other reply worked i appreciate your input, i did have to adjust his formula but it worked perfectly for my brackets