Can Anyone Help me with this
 

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"

Can Anyone Help me with this
 

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

--
Rick (MVP - Excel)


"Kinghart" wrote in message
...

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"




--
Kinghart

Can Anyone Help me with this
 

.... or if D2 <0, or if B2<60 and D2 is 0 and <=1?
--
David Biddulph

"Rick Rothstein" wrote in message
...
It would help to know what range of values b2 and d2 can take. Also, what
should happen if b2=60?

--
Rick (MVP - Excel)


"Kinghart" wrote in message
...

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"




--
Kinghart

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

[quote=Kinghart;717296]*************************************************



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

Can Anyone Help me with this
 

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


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


????

--
Rick (MVP - Excel)

Can Anyone Help me with this
 

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?

OOOOPS.... MY MISTAKE.... THAT FORMULA WORKED SO PERFECTLY..... THANK U VERY MUCH.... U R GENIUS :-)

Can Anyone Help me with this
 

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

"Kinghart" wrote in message
...

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

Can Anyone Help me with this
 

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?