Help with nested IF statement required!

**plannerg** · 08-01-2013, 07:31 AM

Hi,

As below, I am trying to calculate if my team ("Team A) won, lost or drew.

Col A - I have put this in to show you what I mean, but that's the column I want to automate by looking at each teams scores and what they got. I want to do it all with respect to team A though. Is any one able to help me!? Thanks.

Col A Col B Col C Col D Col E

L Team A 56 Team B 139
L Team B 166 Team A 44
D Team A 56 Team B 56
L Team A 28 Team B 111
W Team B 105 Team A 102
L Team B 171 Team A 72
W Team A 72 Team B 63

**Spencer101** · 08-01-2013, 08:36 AM

Assuming your sample data starts with "Team A" in cell B1 and "63" in cell E7, one way would be the following formula in A1 and copying down.
=IF(C1=E1,"D",IF(AND(B1="Team A",C1>E1),"W",IF(AND(D1="Team A",E1>C1),"W","L")))

Worth noting, that in the 5th game in your example you have Team A down as a WIN. However, last time I checked 102 was less than 105 so I make that a LOSS for them...

I'm sure there are nicer ways of accomplishing this, but this works...