Can Anyone Help me with this

[Kinghart]

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

 

[Rick Rothstein]

It would help to know what range of values b2 and d2 can take. Also, what
should happen if b2=60?

 

[David Biddulph]

.... or if D2 <0, or if B2<60 and D2 is >0 and <=1?

 

[Kinghart]

;717295'].... or if D2 <0, or if B2<60 and D2 is >0 and <=1?
--
David Biddulph

It would help to know what range of values b2 and d2 can take. Also, what
should happen if b2=60?

--
Rick (MVP - Excel)



-

*************************************************


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

 

[Rick Rothstein]

*************************************************

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

????

 

[smartin]

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(B2>60,D2>=0),AND(B2<60,D2=0)),"Bingo",IF(AND(B2<60,D2>1),"Sorry","Undefined"))

 

[Kinghart]

Kinghart wrote:-

=IF(OR(AND(B2>60,D2>=0),AND(B2<60,D2=0)),"Bingo",IF(AND(B2<60,D2>1),"Sorry","Undefined"))

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


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

 

[David Biddulph]

Check your typing, or (better option) copy the formula from the newsgroup
and paste into the formula bar, rather than trying to retype.

 

[smartin]

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?