For AND condition
Closed
Ashok
-
7 Mar 2015 à 05:30
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 7 Mar 2015 à 11:08
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 7 Mar 2015 à 11:08
Related:
- For AND condition
- Excel conditional formatting for dates - Guide
- Nested if condition in excel - Guide
- Find and Replace with condition - Excel Forum
- Condition formula - Excel Forum
- Condition date excel - Excel Forum
1 response
cmarzahn
Posts
35
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
13 March 2015
7
7 Mar 2015 à 11:08
7 Mar 2015 à 11:08
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.
