# Help needed with numbers formula

Discussion in 'Mac Apps and Mac App Store' started by paulsalter, Jan 18, 2009.

1. ### paulsalter macrumors 68000

Joined:
Aug 10, 2008
Location:
UK
#1
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

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

2. ### reclusivemonkey macrumors 6502

Joined:
Jun 2, 2008
Location:
Sowerby Bridge, West Yorkshire, UK
#2
You can add a second IF statement to do this.

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

Joined:
Aug 10, 2008
Location:
UK
#3
Thanks