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?