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

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

Find more posts tagged with

Formulas

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.