IF/AND/OR Statements Help To Check A Box When Criteria Met

Lori Flanigan

Hi,

I am trying to write a formula with multiple IF statements with OR and AND to check the appropriate box:

I have this so far and get #INCORRECT ARGUMENT:

=IF(AND(NOT(ISBLANK([Term Date]@row))), OR(Program@row = "ABC", [Shared Programs]@row, OR(@cell = "ABC / XYZ", @cell = "XYZ / ABC")), 1, 0)

Thanks for any help offered!

Lori

Paul Newcome

Try this instead:

=IF(AND([Term Date]@row <> "", OR(Program@row = "ABC", CONTAINS("ABC", [Shared Program]@row))), 1)

Lori Flanigan

Thanks, Paul! That formula works for the Term columns; however, when I change the <>"" to "" for the Active columns, I get *UNPARSEABLE.

Paul Newcome

Can you provide the formula itself?

<>""

means "not blank"

So if you were wanting to change it to say "is blank", you would use

=""

Lori Flanigan

Can you help me understand why the = is used for "" but not for <>""? This is an example of what seems like inconsistencies in formulas that are really confusing.

Thanks for the detail, though. That worked.

Lori

Paul Newcome

=""

means "equal to blank"

<>""

means "not equal to blank".

= --> equal

<> --> not equal

"" --> blank