Oct 06 2021 10:20 AM
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?
Oct 06 2021 10:27 AM
=IF(OR(C37="",D37=""),"",IF(C37>D37,"W","L"))