MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text Value Response to Input

October 15, 2001 - by Bill Jelen

Charlie from Cleveland writes:

Assume you are miraculously beating the best team in baseball 2 games to 1 in a best of five series. Your ace pitcher starts to look weary in the 6th inning and then gets in trouble in the 7th inning. Can you show me a formula in Excel to tell if I should pull him out of the game?

Sure, Charlie, it would take a simple If formula. These come in real handy the next time you have a chance to pull off an incredible upset. Try a simple formula like this in cell A1:

=IF(Bartolo="Weary","Absolutely Pull Him Out of the Game","Pull Him Out of the Game Anyway")

Congratulations to all Seattle Mariner fans. Although MrExcel would have enjoyed watching our Wahoos advance to the ALCS, I have to admit that this is Seattle's year, and it would not have been right for them to have not advanced for a chance at the Pennant. Best of luck in the ALCS.

Bill Jelen is the author / co-author of
MrExcel LX – The Holy Grail of Excel Tips

A book for people who use Excel 40+ hours per week. Illustrated in full color.