How to write one single line of VBA code to return TRUE/FALSE for And/Or statement?

Statement #1: (A1=1 AND (A2 <> 3 OR A3 > 5)) OR ((A4>9 OR A5 <= 8) AND A6 > 20)

Statement #2: OR( AND(A1=1, OR(A2 <>3, A3 >5)), AND(OR(A4>9, A5 <=8),A6 >20) )

Please Login or Register  to view this content.

Attached Photo: Yellow cells are filled with numbers.

How to write one single line of code for RED portion of code? The code can be in either format of Statement 1 or Statement 2.

E.g. If A1=35, then A1=1 is False. Or I can write separate code to figure out if A1 = 1 is True or False, then replace A1=1 with True/False. Red portion can also be something like(if I decide to break above Red portion of code into two steps. First step: figuring out True/False for each substatement):
(False AND (True OR True)) OR ((False OR True) AND True)

Thanks.

Statement #1 and Statement #2 are already valid VBA logical expressions that you can use in your code.

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

Statement #1 and Statement #2 are already valid VBA logical expressions that you can use in your code.

Please Login or Register  to view this content.

Thanks. Do you know why the string (below code) does not work? For some reason, people need to write syntax with prefix (prefix means something, I would briefly explain a little, e.g. C.A1 means Current Year A1, P.A1 means Previous year A1): C.A2 > 5 Or P.A5 <> 7

Prefix determines where to pull data from, BUT I cannot use prefix in IF statement directly, Prefix cannot even be used as variable, I can not write Dim C.A1 As Integer

So before writing If....Then statement, I need my program to look at each sub-statement ( C.A2 > 5 & P.A5 <> 7) and determine if they are True or False

First step: I write Str = "C.A2 > 5 Or P.A5 <> 7"
Second Step: I look at current year table and determine if C.A2 > 5 is True or False, if it is True, I will substitute it with True. Str = "True Or P.A5 <> 7"
Third Step: I look at previous year table and determine if P.A5 <> 7 is True or False, if it is False, I will substitute it with False. Str ="True Or False"

But at this point, I only have variable Str , but If Str Then cannot be compiled.

However, If True Or False Then can be compiled. The issue is I only have the variable Str, I could not find a way to write If True Or False Then directly, If True Or False Then is from multiple steps of substitutions.

How can I go around the issue? In other words, how to write If C.A2 > 5 Or P.A5 <> 7 Then ? Maybe I should write Dim Str As Boolean , but I still cannot find a way to write code to figure out if it is true or false for C.A2 > 5 Or P.A5 <> 7

C.A2 > 5 Or P.A5 <> 7 is what I have from other party, I cannot change the way other people to write the statement, my role is to write code and determine if the statement is True or False.

Please Login or Register  to view this content.