The opponent is in column "A", our team score is in column "B" and the opponent score is in column "C". I'd like for the result formula to be in column "D".

Below is the formula that I have working to get wins and losses.

=IF(B3>C3,"W","L")

I tried the following formula to also track if the game ended in a tie but I'm having trouble with it.

=IF(B3>C3,"W","L",IF(B3=C3,"T"))

Is there a formula to track all three result possibilities? Thanks for your help!