working on double elimination bracket need help with formula

nathanaelgjones1018 

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!

Hope this will help you.

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

This will help all forum participants.