MS Excel IF

[TimReeks]

I want to include the cell contents in the True result of an IF statement, as in IF(E2>M2, "Team Name in D2 WIN", IF(E2<M2, "TeamName in L2 WIN", "DRAW"). So the result of the True statement is a Team name from either D2 or L2 depending on which team won, and "WIN".?

 

[Sergius]

Hello! This should work.

=IF(E2>M2;D2 &" "& "WIN";IF(E2<M2;L2 &" "& "WIN";"DRAW"))

 

[etaf]

IF(E2>M2, "Team Name in D2 WIN", IF(E2<M2, "TeamName in L2 WIN", "DRAW").
IF(E2>M2, D2&" WIN", IF(E2<M2, L2&" WIN", "DRAW").

 

[Jette3173]

Book1
	A	B	C
1	Team Name 1	Team Name 2
2	14	7	Team Name 1 Win
3	9	21	Team Name 2 Win
4	3	3	Draw
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=IFS(A2>B2,$A$1&" Win",B2>A2,$B$1&" Win",A2=B2,"Draw")

 

[Fluff]

Hi & welcome to MrExcel.
Another option

=CHOOSE(SIGN(E2-M2)+2,L2&" win","Draw",D2&" Win")