IF function

[Irish]

I have made a spreadsheet for a sports competition. I have it set up so that
when I add the scores, the draw updates. ie. if I add the scores for 1/4
final matches, the appropriate teams appear in the semi final slots.

Until I add scores, the word FALSE appears in the cells. My question is how
can I make it so that the letters"TBD" appear instead of FALSE?

 

[T. Valko]

Post your formula.

 

[Irish]

=IF(F30*3+G30>F31*3+G31,E30,IF(F31*3+G31>F30*3+G30,E31))

thanks

 

[T. Valko]

Try this:

=IF(F30*3+G30>F31*3+G31,E30,IF(F31*3+G31>F30*3+G30,E31,"TBD"))

 

[Irish]

Yep, that worked great.

thanks tvalko

Try this:

=IF(F30*3+G30>F31*3+G31,E30,IF(F31*3+G31>F30*3+G30,E31,"TBD"))

 

[T. Valko]

You're welcome. Thanks for the feedback!