If then AND statements in access

S

Sarah

I am trying to convert this excel IF statement into access.

=IF(A2<-10,"OK",IF(AND(@240<-5,B2="Y"),"OK","Not OK"))

How would I write this in access?
 
S

Sarah

I am trying to convert this excel IF statement into access.

=IF(A2<-10,"OK",IF(AND(@240<-5,B2="Y"),"OK","Not OK"))

How would I write this in access?
Click to expand...

Oops - This is what the statement is..
 
J

Jerry Whittle

Well there aren't any cells like B2 in Access. We would need the field names.

Also it would help if you showed us some sample data and what you would like
the result to look like.
 
C

Clifford Bass

Hi Sarah,

This would be an equivalent:

=IIf(A2<-10,"OK",IIf(A2<-5 AND B2="Y","OK","Not OK"))

Or this:

=IIf(A2<-10 OR (A2<-5 AND B2="Y"),"OK","Not OK")

Clifford Bass
 
Top