I keep getting "unparseable" ... what am I doing wrong?
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!
Best Answer
-
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.
Answers
-
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.
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!