=IF(AND(B2,D2,F2<1:50),"Fail","Pass") please correct the formula

[Guest]

=IF(AND(B2,D2,F2<1:50),"Fail","Pass") please correct the formula

 

[Douglas J. Steele]

What you've posted is an Excel formula. You stand a much better chance of
getting an answer if you ask in a newsgroup related to Excel.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

 

[Rod Makin]

Yeah and you may want to add some clarity of what your expecting

 

[Guest]

But since you're here, try putting the ")" between the ref to F2 & the <. I'm
not sure what the 1:50 is supposed to be, but you might check to see that it
is expressed correctly (1.5, 150 ?).

HTH |:>)

 

[Dreama]

What you want is
=IF(AND(B2,D2,F2<TIMEVALUE("1:50")),"Fail","Pass")
1:50 is a text representation of a serial number.

DLM