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