If And with greater than but less than statement

[ecrodrig]

Hello everyone,

I am trying to do an IF AND statement that does the following (what I want may be wishful thinking ) but here goes.

I want to say if A > B or A is equal to C, then True But needs to be inside an If(ANd statement because I have another condition that also needs to be met So the whole thing would be something like:

IF(AND( OTC="Closed", "A>B or A is = to C"), "Verified", "Check")

I would need help with the "A>B, or A is = to C" section.

Any help or suggestions would be greatly appreciated. Thanks

 

[Joe4]

You can nest ORs inside of ANDs, i.e.

=IF(AND(OTC="Closed",OR(A>B,A=C)), "Verified", "Check")

NOTE: You didn't say what A,B, and C were. So really they are just place-holders here for whatever they are supposed to be.
If they are ranges, they will need a row component to them.

 

[Jeffrey Mahoney]

Please try this
IF(AND(OTC="Closed",OR(A1>B1,A1=C1)),"Verified","Check")