Hello,
I am in the process of creating the table for a soccer league. I have a formula that takes the goals for and goals against and determines if it is a win, tie, or loss. However, when there is no data in the goals for or against cells, the formula yields a tie. Is there any way to make the formula not have a value until there is values in the goals for and against cells?

The formula I'm using for determining win, draw, or loss is =IF(D5>E5,"W",IF(E5>D5,"L",IF(D5=E5,"D")))

D5= Goals for
E5= Goals Against

Feel free to reply with a response or a question if you need clarification. Thanks!