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.

Friendly 2
TEAM NAMES	Team Scores
Navy U9	3
Yellow U9	2

<colgroup><col span="4"></colgroup><tbody>
</tbody>

<colgroup><col span="2"><col span="2"></colgroup><tbody>
</tbody>

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.