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

PeggyLang

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?

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)

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)

PeggyLang

@JamesB LIFESAVER!!!!

THANK YOU!!

JamesB

Your Welcome