Forum Discussion

nathanaelgjones1018's avatar
nathanaelgjones1018
Copper Contributor
May 05, 2024

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.

 

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

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.

  • nathanaelgjones1018 

    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.

     

    • nathanaelgjones1018's avatar
      nathanaelgjones1018
      Copper Contributor
      so the other reply worked i appreciate your input, i did have to adjust his formula but it worked perfectly for my brackets

Resources