HI
Got a problem with an IF and THEN statement that hopefully a member can help me with.
We have a tournament of 32 teams comprising of 64 people.
They have been already assigned to separate brackets .
I need to advance them to the next bracket if they win and a alternate bracket if they lose.
I have a WIN/LOSS (D7/D3) field that I hoped to use with either a score(numeric) or just a simple (W) or (L)
The problem I am running into is that the formula IF=D7>D3, C3,C7 moves players to WIN Side Bracket
If the field (D7/D3) is blank, it will pick a winner and move them forward.
So basically, I would like the formula only to be used if values are in the WIN/LOSS D7/D3 fields.
I know I need a compound/nested IF statement, but just cant seem to get it right !
Bookmarks