Can Anyone Help me with this

  • Thread starter Thread starter Kinghart
  • Start date Start date
K

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
 
It would help to know what range of values b2 and d2 can take. Also, what
should happen if b2=60?
 
'David Biddulph[_2_ said:
;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)



-
Click to expand...
Click to expand...

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


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
 
*************************************************
+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
Click to expand...


????
 
smartin;717554 said:
Kinghart wrote:-

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

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


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