Iif and + or (1 Viewer)

jeran042 · Jun 6, 2019

Here is what I am trying to do,
I need to meet three conditions. If txt_1 is above 5 OR less than -5 AND txt_2 is greater than 5000.

Not sure how to go about this. Here is what I have so far.

Any help or guidance is appreciated,

Code:

=IIf([txt_1]>="5",IIf([txt_1]<="-5" And [txt_2]>="5000","TRUE","FALSE"))

theDBguy · Jun 6, 2019

Hi. How about?

Code:

IIf((txt_1>5 OR txt_1<-5) AND (txt_2>5000),True,False)

plog · Jun 6, 2019

txt_1 is above 5 OR less than -5 AND txt_2 is greater than 5000

In English, that's ambiguous. You need to express that mathematically to be clear. Do you mean:

A: (txt_1>5 OR txt_1<-5) AND txt_2>5000
Or
B: txt_1>5 OR (txt_1<-5 AND txt_2>5000)

When you mix ANDs and ORs you need to be explicit by using parenthesis.

Mark_ · Jun 6, 2019

IIF( ABS(Me.Txt_1) > 5, IIF(me.txt_2 > 5000, TRUE, FALSE), FALSE)

jeran042 · Jun 6, 2019

This worked, Thank you!

theDBguy · Jun 6, 2019

jeran042 said:
This worked, Thank you!

Hi. Glad to hear you got it sorted out. Good luck with your project.

Iif and + or (1 Viewer)

jeran042

Registered User.

theDBguy

I’m here to help

plog

Banishment Pending

Mark_

Longboard on the internet

jeran042

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread