If Blank than Blank

Question

Hey Guys,
Trying to figure out how to leave a cell BLANK.
I’m tracking soccer games.
Here’s my formula:
IF({Home Score} > {Away Score}, {Home Team} & " " & “Wins!!”,IF({Away Score}>{Home Score},{Away Team} & " " & “Wins!”,IF({Home Score}={Away Score},“Draw”)))
The first part is ok. I get the right values for HOME / AWAY &  DRAW. the problem is with future games, where the “score” cells are still empty, I get “Draw”. technically it’s true, but I’d like to leave the cell empty or insert a placeholder text instead.
Thanks in advance.

Kamille_Parks11 · Accepted Answer

You’ll want to first check if both scores are empty (or alternatively, if both scores are entered), then run the rest of your formula.

IF(AND({Home Score}, {Away Score}), IF({Home Score} > {Away Score}, {Home Team} & " Wins!", IF({Away Score} > {Home Score}, {Away Team} & " Wins!", IF({Home Score} = {Away Score}, "Draw"))))

You can also simplify your formula a little like so:
IF(AND({Home Score, {Away Score}), IF({Home Score} = {Away Score}, "Draw", IF({Home Score} > {Away Score}, {Home Team}, {Away Team}) & " Wins!"))

Thanks kamille! I really appreciate it.

Omer_Nesher · Answer

You’ll want to first check if both scores are empty (or alternatively, if both scores are entered), then run the rest of your formula.

IF(AND({Home Score}, {Away Score}), IF({Home Score} > {Away Score}, {Home Team} & " Wins!", IF({Away Score} > {Home Score}, {Away Team} & " Wins!", IF({Home Score} = {Away Score}, "Draw"))))

You can also simplify your formula a little like so:
IF(AND({Home Score, {Away Score}), IF({Home Score} = {Away Score}, "Draw", IF({Home Score} > {Away Score}, {Home Team}, {Away Team}) & " Wins!"))

Thanks kamille! I really appreciate it.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded