If Cell A is NOT blank AND Cell B is Not blank

I'm having trouble with my syntax I believe. I need to determine if Cell A AND Cell B are NOT BLANK then execute a function otherwise leave Cell C blank.

The below is what I thought would work, however, I'm getting 'unpaseable'

=IF(AND(NOT(ISBLANK([Case Product Removed]@row)), (NOT(ISBLANK([Case Product Re-Stocked]@row)), [Construction Start]@row - 14)

What am I doing wrong?

Find more posts tagged with

Formulas

Accepted answers

JamesB

@PeggyLang Looks like you had some characters incorrect in your formula. Your second NOT statement should not have the Open Parentheses, and your AND statement should close before the True statement of your IF expression. See the adjusted formula below.

=IF(AND(NOT(ISBLANK([Case Product Removed]@row)), NOT(ISBLANK([Case Product Re-Stocked]@row))), [Construction Start]@row - 14)

All comments

JamesB

=IF(AND(NOT(ISBLANK([Case Product Removed]@row)), NOT(ISBLANK([Case Product Re-Stocked]@row))), [Construction Start]@row - 14)

PeggyLang

@JamesB LIFESAVER!!!!

THANK YOU!!

JamesB

Your Welcome

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.