Can you have multiple If functions in one cell

[Oakey]

Hi,

Can you use multiple IF function formulas in one cell to return a specific value?

Im looking for a formula that will return a value of 'Win, Draw, Lost' from a result.

[TABLE="width: 196"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD="colspan: 4"]Friendly 2[/TD]
[/TR]
[TR]
[TD="colspan: 2"]TEAM NAMES[/TD]
[TD="colspan: 2"]Team Scores[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Navy U9[/TD]
[TD="colspan: 2"]3[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Yellow U9[/TD]
[TD="colspan: 2"]2[/TD]
[/TR]
[TR]
[TD="colspan: 4"]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 246"]
<colgroup><col span="2"><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 4"] [/TD]
[/TR]
</tbody>[/TABLE]
Teams are in cells A3 and A4, Scores are in cells B3 and B4, i would like the result in A5.

The result would show either Win, Draw or Lost

Thanks for your help

 

[Nishant94]

Book1
	A	B	C
2	TEAM NAMES	Team Scores	Result
3	Navy U9	3	Win
4	Yellow U9	2	Lose
Sheet9

Cell Formulas
Range	Formula
C3	=LOOKUP(2*B3-SUM($B$3:$B$4),{-9.99E+307,"Lose";0,"Draw";1,"Win"})

 

[Oakey]

Thank you very much for this...works wonders

 

[jtakw]

Book1
	A	B	C
2	TEAM NAMES	Team Scores	Result
3	Navy U9	3	Win
4	Yellow U9	2	Lose
Sheet9

Cell Formulas
Range	Formula
C3	=LOOKUP(2*B3-SUM($B$3:$B$4),{-9.99E+307,"Lose";0,"Draw";1,"Win"})

Thank you very much for this...works wonders

Hi,

Really, this is producing the results you want? From post #2 :

Book1
	A	B	C
1
2	TEAM NAMES	Team Scores
3	Navy U9	3	Lose
4	Yellow U9	2	Lose
5	Red X9	3	Lose
6	Purple A8	1	Lose
Sheet150

Cell Formulas
Range	Formula
C3	=LOOKUP(2*B3-SUM($B$3:$B$6),{-9.99E+307,"Lose";0,"Draw";1,"Win"})

 

[Oakey]

Yeah from post 2 works for the sheet that i have put it on

 

[jtakw]

okay, great for you.