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)
Best Answer
-
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)
Answers
-
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)
-
I can't believe I missed that. The " " worked. thanks
-
@Kim Bowie Sometimes it's the simplest things that trip us up because we're looking for complex problems!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 217 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!