I keep getting "unparseable" ... what am I doing wrong?

sarah.e2.davis

I have 3 columns (A, B, C) with yes/no responses.

I want column D to return a response of "contractor" if the response to Column A = yes , Column B = yes, and Column C = no.

I have been trying:

=IF(AND([A]1 = "yes", [B]1 = "yes", [C]1 = "no"), "contractor")

What am I doing wrong? THANK YOU!

Find more posts tagged with

Formulas

Accepted answers

Carson Penticuff

This looked correct to me, so I created a test sheet and pasted your formula directly in… works perfect for me.

Did you copy/paste your formula into your post, or retype it manually? Maybe trying copy/paste back into your grid from your original post.

All comments

Carson Penticuff

This looked correct to me, so I created a test sheet and pasted your formula directly in… works perfect for me.

Did you copy/paste your formula into your post, or retype it manually? Maybe trying copy/paste back into your grid from your original post.

sarah.e2.davis

Ummm… overnight magic! I have no idea why it didn't seem to like it last night, but when I opened up the sheet this morning, voila! It was working.

Thanks for the confirmation, Carson - I appreciate it!

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.