Kinghart wrote:
smartin;717554 Wrote:
Kinghart wrote:-
If b2 is 60 and d2 is =0 then g2 = "Bingo"
If b2 is <60 and d2 is =0 then g2 = "Bingo"
If b2 is <60 and d2 is 1 then g2 = "Sorry"-
=IF(OR(AND(B260,D2=0),AND(B2<60,D2=0)),"Bingo",I F(AND(B2<60,D21),"Sorry","Undefined"))

HEY THANKS..... THAT FORMULA ALMOST WORKED, BUT STILL HAVE SOME
PROBLEMS WITH THE "SORRY" PART.... #NAME?


Kinghart,

Kindly use the Caps Lock key so your messages are not in all caps before
posting.

I based the formula on your criteria; it should work unless I missed
something.

What formula did you try?