Excel If Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2818696%22%20slang%3D%22en-US%22%3EExcel%20If%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2818696%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20columns.%20In%20Column%20C%20is%20the%20score%20of%20one%20team%20and%20Column%20D%20is%20the%20score%20of%20the%20opponent.%20In%20Column%20E%2C%20I%20have%20the%20formula%26nbsp%3B%3DIF(C37%26gt%3BD37%2C%22W%22%2C%22L%22).%20However%2C%20if%20the%20scores%20are%20not%20posted%20into%20the%20other%20two%20columns%20yet%2C%20I%20want%20Column%20E%20to%20be%20blank.%20How%20do%20I%20expand%20on%20my%20formula%20to%20make%20that%20happen%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2818696%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2818729%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20If%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2818729%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1177425%22%20target%3D%22_blank%22%3E%40Monica2320%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(OR(C37%3D%22%22%2CD37%3D%22%22)%2C%22%22%2CIF(C37%26gt%3BD37%2C%22W%22%2C%22L%22))%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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!