Susannah68
New Member
- Joined
- Oct 6, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi,
I'm trying to create a formula where all the conditions have to be met to return a "Yes". The conditions to return "Yes" are, 1st cell must be blank, 2nd cell's date must be less than today's date, 3rd cell to exclude "apples" or "pears" from a multiple list of fruit and 4th cell to exclude "Closed" from a multiple list.
I've tried =IF(AND(NOT, but the formula applies NOT to the first argument or it tells me I have too many arguments. Is it possible to have a NOT argument in the same formula?
thank you
S
I'm trying to create a formula where all the conditions have to be met to return a "Yes". The conditions to return "Yes" are, 1st cell must be blank, 2nd cell's date must be less than today's date, 3rd cell to exclude "apples" or "pears" from a multiple list of fruit and 4th cell to exclude "Closed" from a multiple list.
I've tried =IF(AND(NOT, but the formula applies NOT to the first argument or it tells me I have too many arguments. Is it possible to have a NOT argument in the same formula?
thank you
S