Excel If Formula

Copper Contributor

I have two columns. In Column C is the score of one team and Column D is the score of the opponent. In Column E, I have the formula =IF(C37>D37,"W","L"). However, if the scores are not posted into the other two columns yet, I want Column E to be blank. How do I expand on my formula to make that happen?

2 Replies

@Monica2320 

=IF(OR(C37="",D37=""),"",IF(C37>D37,"W","L"))

Thank you so much! That worked!