IF function
 

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?

IF function
 

Post your formula.


--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
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?

IF function
 

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

thanks

"T. Valko" wrote:

Post your formula.


--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
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?

IF function
 

Try this:

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


--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
=IF(F30*3+G30F31*3+G31,E30,IF(F31*3+G31F30*3+G30 ,E31))

thanks

"T. Valko" wrote:

Post your formula.


--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
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?

IF function
 

Yep, that worked great.

thanks tvalko

"T. Valko" wrote:

Try this:

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


--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
=IF(F30*3+G30F31*3+G31,E30,IF(F31*3+G31F30*3+G30 ,E31))

thanks

"T. Valko" wrote:

Post your formula.


--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
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?

IF function
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
Yep, that worked great.

thanks tvalko

"T. Valko" wrote:

Try this:

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


--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
=IF(F30*3+G30F31*3+G31,E30,IF(F31*3+G31F30*3+G30 ,E31))

thanks

"T. Valko" wrote:

Post your formula.


--
Biff
Microsoft Excel MVP


"Irish" wrote in message
...
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?