Help with Unparseable If(And) formula

RScapperotti

Please help with reviewing the formula below. I am getting #UNPARSEABLE.

=IF(AND([Spend 2022]@row=0,[Spend 2023]@row=0,[Compliance Status]@row<>”Active-NonCompliant”),"Y", "N")

If I only do the single IF, it returns the value correctly : =IF([Spend 2022]@row = 0, "Y", "N")

[Spend 2022] and [Spend 2023] columns are text (currency), and [Compliance Status] is a dropdown.

Thank you!

Find more posts tagged with

Formulas

Accepted answers

JMcI

Looks like you have slanted or "smart quotes" round your ”Active-NonCompliant”, replace them with what you have on "Y" and "N"

=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "Active-NonCompliant"), "Y", "N")

All comments

Colleen Patterson

@RScapperotti

=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "Active-NonCompliant"), "Y", "N")

I was able to get this formula to work under your same criteria.

JMcI

Looks like you have slanted or "smart quotes" round your ”Active-NonCompliant”, replace them with what you have on "Y" and "N"

=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "Active-NonCompliant"), "Y", "N")

RScapperotti

Thank you both! I copied and pasted your formulas and they worked. I believe it was the smart quotes.

JMcI

Great!

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.