Hi Lisa,

This is exactly what I'm looking for but it doesn't quite work. I've
tried a test and entered value for D1 as "A" and E1 as 320, but I'm
still getting "LOSS" when it should be "WIN".

Thanks a ton for your help, hopefully you'll indulge me a little more.

vencopbrass Wrote:
Here is another way to do it.
Type or paste this into F1 or wherever you want the win/loss to show
up.
Then drag it down to fill in the other rows.
=IF(AND(D1="A",E1<340),"WIN",IF(AND(D1="B",E1<350) ,"WIN",IF(AND(D1="C",E1<350),"WIN",IF(AND(D1="D",E 1<300),"WIN",IF(AND(D1="E",E1<280),
"WIN",IF(AND(D1="F",E1<250),
"WIN",IF(AND(D1="G",E1<230),"WIN","LOSS")))))) )

Lisa


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=516907