Formula Error

Bryan Letourneau

Hi Community,

I needed to adjust a formula to perform an OR function instead of an AND function and now I'm receiving an error that I can't seem to correct.

The issue lies in the first section of the formula to produce a "green" value if true.

Any help would be greatly appreciated!

Jeff Reisman

@Bryan Letourneau

I think you need to embed the OR inside the AND, as if the whole OR statement is one of the options within the AND. Having the OR and the AND as separate logical expressions is breaking the IF syntax. Be sure to close off the OR as well as the AND with end parentheses.

Ex. - =IF(AND(A=1, B=2, OR(C=3, D=4), E=5), "True", "False")

Jeff Reisman

@Bryan Letourneau

I think you need to embed the OR inside the AND, as if the whole OR statement is one of the options within the AND. Having the OR and the AND as separate logical expressions is breaking the IF syntax. Be sure to close off the OR as well as the AND with end parentheses.

Ex. - =IF(AND(A=1, B=2, OR(C=3, D=4), E=5), "True", "False")

Bryan Letourneau

Thanks @Jeff Reisman , that did the trick!