S
Sajid
=IF(AND(B2,D2,F2<1:50),"Fail","Pass") please correct the formula
D
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.
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.
R
Rod Makin
Yeah and you may want to add some clarity of what your expecting
C
CyberTaz
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 |:>)
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 |:>)
D
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
=IF(AND(B2,D2,F2<TIMEVALUE("1:50")),"Fail","Pass")
1:50 is a text representation of a serial number.
DLM