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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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

'David Biddulph[_2_ Wrote:
> ;717295'].... or if D2 <0, or if B2<60 and D2 is >0 and <=1?
> --
> David Biddulph
>
> "Rick Rothstein" <(E-Mail Removed)> wrote in message
>
> news:(E-Mail Removed)...-
> > 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...-
> >>
> >> 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-
> > -

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


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



--
Kinghart

> *************************************************
>
>
> +-------------------------------------------------------------------+
> +-------------------------------------------------------------------+


????

--
Rick (MVP - Excel)

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(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?


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



--
Kinghart

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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(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?
>
>
> +-------------------------------------------------------------------+
> +-------------------------------------------------------------------+
>
>
>
> --
> Kinghart