SOLVED

# working on double elimination bracket need help with formula

Copper Contributor

# 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.

3 Replies
best response confirmed by nathanaelgjones1018 (Copper Contributor)
Solution

# Re: 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:

1. 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.
2. 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!

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

# Re: working on double elimination bracket need help with formula

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.

# Re: working on double elimination bracket need help with formula

so the other reply worked i appreciate your input, i did have to adjust his formula but it worked perfectly for my brackets
1 best response

Accepted Solutions
best response confirmed by nathanaelgjones1018 (Copper Contributor)
Solution

# Re: 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:

1. 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.
2. 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!