Forum Discussion
Monica2320
Oct 06, 2021Copper Contributor
Excel If Formula
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
=IF(OR(C37="",D37=""),"",IF(C37>D37,"W","L"))
- Monica2320Copper ContributorThank you so much! That worked!