I am trying to set up a bracket similar in style to the NCAA tournament 64 team bracket to determine a daily lunch champion.

Currently, I have a model which has buttons to click for each round where each champion is decided using an if then statement with the Rnd function. The code looks something like this:

Sub Button2_Click()

If Rnd > 0.5 Then
    Range("C3").Select
    ActiveCell.FormulaR1C1 = "=R[-1]C[-1]"
    Else
    Range("C3").Select
    ActiveCell.FormulaR1C1 = "=R[1]C[-1]"
    End If
    
    If Rnd > 0.5 Then
    Range("C7").Select
    ActiveCell.FormulaR1C1 = "=R[-1]C[-1]"
    Else
    Range("C7").Select
    ActiveCell.FormulaR1C1 = "=R[1]C[-1]"
    End If
It continues with If/Then statements for the remaining 30 "match-ups" in the first round. Unfortunately, using the model this way gives the same "winner" every time you open the model and run it for the first time. Is there a way to better randomize in Excel or should I scrap this approach and do something completely different?

Any and all help will be appreciated. As I'm sure you can tell, I am not a computer programmer by trade.