Setting a 3rd BOOLEAN statement, based on two others...

[Darth269]

Hi folks,

I've two Boolean variables.

I need an if statement (or something else if there's something better) that checks the two and sets a third to TRUE only if the first two are the same, TRUE or FALSE, doesn't matter.

Any ideas?

[martindwilson]

isn't that just AND =and(a1="x",b1="X") OR JUST =A1=B1

[Marcol]

Or maybe ...
=(B2=C2)=(D2=E2)

[Darth269]

The sheet works, but I'm running a large(ish) vba script and it's this (nothing on the worksheet itself) that I need to set the variables on.

VARIABLE_1
VARIABLE_2
VARIABLE_3

Number 3 is true if 1 & 2 are the same, regardless of their state.

Sorry if what you've sent IS applicable, and I just don't get it...

[martindwilson]

something like

Please Login or Register  to view this content.

[Darth269]

So in other words I need to represent this on the sheet somewhere? It can't be handled in the script alone?

[Norie]

What are VARIABLE_1,2 and 3 exactly?

How are VARIABLE_1 and 2 getting their values?

[martindwilson]

that was just a sample you can set the value of j and k from anywhere i just put it like that so i could see it working

[Darth269]

They are true/false conditions that get used in the script and for output, but until the end of the script there's nothing on the sheet to represent this. I believe I've managed to resolve this with the following...

Please Login or Register  to view this content.