If formula adjust for win lose game

[vasc]

Hi my friend

I have one formula for win all games (yellow cell)
search formula in lose one game (red cell)

little help need .....

thanks in advance BO_RY

[Aardigspook]

I'm not sure why you're addressing Bo_ry directly, unless you've sent him a private message?

Your formula for winning all games doesn't work - try changing C2 to 'lose' and it will still show 'win all' as the nested IF then just moves on to check the next one.
Try this instead:

Please Login or Register  to view this content.

If there will always be five games, you could change the '=COUNTA(A2:F2)' to '=5'.
It will return 'Win All' if all the cells contain 'win' or, if not, will give the game with the first loss only.