For AND condition
Closed
Ashok
-
Mar 7, 2015 at 05:30 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Mar 7, 2015 at 11:08 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Mar 7, 2015 at 11:08 AM
Related:
- For AND condition
- Available memory less than 15mb condition zero - Guide
- If condition in excel - Guide
- Your phone is optimal condition meaning - Guide
- Excel copy value if condition met ✓ - Excel Forum
- Excel clear cell contents based on condition ✓ - Excel Forum
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Mar 7, 2015 at 11:08 AM
Mar 7, 2015 at 11:08 AM
Not a lot to go on with your question Ashok...
I think you are asking about the format for an AND statement for conditions in two different columns.
Something like =if(AND(B1=1,C1=1),2,"") might help you in thinking about it.
If something (The AND statement) then 2 else blank is the way to read that.
As for the AND statement -- it is saying AND B1 equals 1 and C1 equals 1,
so the whole statement would read:
if both B1=1 and C1=1 then 2 else blank.
Hope that helps.
I think you are asking about the format for an AND statement for conditions in two different columns.
Something like =if(AND(B1=1,C1=1),2,"") might help you in thinking about it.
If something (The AND statement) then 2 else blank is the way to read that.
As for the AND statement -- it is saying AND B1 equals 1 and C1 equals 1,
so the whole statement would read:
if both B1=1 and C1=1 then 2 else blank.
Hope that helps.
