IF AND with check box and other criteria

I'm sure I'm just missing a comma or something silly that my brain is not catching, but can I get an assist on this one?

Deducted from Purchase Price is a check box column

Accepting Extention? is a text column

I want to add the value from the Amount Due column if the check box is checked and if the cell in Accepting exertion is Yes. I keep getting an #unparseable error message.

=IF(AND([Deducted from Purchase Price]@row = 1, [Accepting Extension?]@row = Yes), [Amount Due]@row,0)

Find more posts tagged with

Accepted answers

Heather Duff

Hi @Kim Bowie ,

Try putting quotation marks around yes. That should fix it:

=IF(AND([Deducted from Purchase Price]@row = 1, [Accepting Extension?]@row = "Yes"), [Amount Due]@row,0)

All comments

Heather Duff

Hi @Kim Bowie ,

Try putting quotation marks around yes. That should fix it:

=IF(AND([Deducted from Purchase Price]@row = 1, [Accepting Extension?]@row = "Yes"), [Amount Due]@row,0)

kim b

I can't believe I missed that. The " " worked. thanks

Heather Duff

@Kim Bowie Sometimes it's the simplest things that trip us up because we're looking for complex problems!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.