Text Function

[guamlenahans]

I thought this would be easy (probably is) but I cant seem to figure it out. In cell F5, I have a string of text. I need, in cell G5, put either 'Win" or "Lose", based on F5.

F5 would be something like: W,W,W,L,W,W, : So G5 would be "Lose"
or: W,W,W,W So g5 would be "Win".

If F5 is blank I would to keep G5 blank.

Thanks is advanced.

rob

 

[Norie]

Try this formula, though there's probably a better solution.

=IF(COUNTIF(F5,"*L*"),"Lose","Win")

 

[guamlenahans]

Thanks! had to modify it for the blank but no sweat doing that!