Help needed with numbers formula

[paulsalter]

I am sure this is an easy one (dont often use spreadsheets) but cannot figure this out

I am trying to do a sporting spreadsheet and based upon scores automatically fill in the names for the next round

The spreadsheet is fairly simple
Name A, Name A Score, Name B, Name B Score (A1,B1,C1,D1)

From this I want the winner (first to 6) to be automatically added into next round, so in the next round box I have

=IF(B1=6,A1,C1)

Which works correctly but I do not want to do this if the result is blank, or ideally only do this if one of the results is 6 (without a score it puts Name B as winner)

Like this, but I cant figure out how to do this as a formula
If B1=6 then fill this box with A1, If D1=6 the fill this box with C1

Thanks for any help

 

[reclusivemonkey]

You can add a second IF statement to do this.

=IF(C3>=6,B3,IF(E3>=6,D3,""))

 

[paulsalter]

You can add a second IF statement to do this.

=IF(C3>=6,B3,IF(E3>=6,D3,""))

Thanks