Hi All,
As you can see in my example I have used IF+AND function in Column C, but it doesn't work.
Any idea where I'm wrong?
Thank you in advance!
Hi All,
As you can see in my example I have used IF+AND function in Column C, but it doesn't work.
Any idea where I'm wrong?
Thank you in advance!
It would help if you explained what you want this formula to do.
This expression
AND(B2="NBD",D2="Monday",D2="Tuesday",D2="Wednesday",D2="Thursday")
will always be FALSE because D2 can only have only value; it cannot have Monday AND Tuesday AND Wednesday, etc.
Could it be--and I am just guessing here--that you mean
AND(B2="NBD",OR(D2="Monday",D2="Tuesday",D2="Wednesday",D2="Thursday"))
That is, B2 is NBD and D2 is any of those days?
Same problem with your other AND expressions.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Try ...
=IF(AND(B2="NBD",OR(D2="Monday",D2="Tuesday",D2="Wednesday",D2="Thursday")),A2+1,IF(AND(B2="NBD",OR(D2="Friday",D2="Saturday")),A2+3,IF(AND(B2="NBD",D2="Sunday"),A2+2,"")))
You need OR test for D2: it cannot be MODAY AND Tuesday - it is Monday OR Tuesday OR ..... etc.
Hi
=AND(D2="Monday";D2="Tuesday") never occurs, =OR(D2="Monday";D2="Tuesday") maybe.
Regards
Thank you John!
Working as I wish!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks