asked on if statement "m2" or "lm"- excel 2010
hi experts, id like some help with the following formula
=if(or(c12=c6,c12=c7),"m2"
basically if c12= c6 or c7 then show "m2" and if c12 = c8, c9, c10 or c11 then show "lm"
=if(or(c12=c6,c12=c7),"m2"
basically if c12= c6 or c7 then show "m2" and if c12 = c8, c9, c10 or c11 then show "lm"
Microsoft Excel
Last Comment
mark_harris231
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
hi byundt, i tried this formula but it did not work
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
What result did you get with Brad's (byundt) formula? I can't see how it would not work for what you describe - unless your excel version is actually 2003 or earlier?
Please post a sample workbook that demonstrates the formula not working.
Agree with byundt and rorya - byundt's solution should work.
Points to byundt please, but I did want to post an alternative using the CHOOSE function that might be useful when the criteria set is greater than two conditions:
- if C12= C6, then "m2"
- if C12=C7, then "q9"
- if C12 = C8, then "lm"
- if C12 = C9, then "lmno"
- if C12 = C10 or C11, then "xyz"
=CHOOSE(MATCH(C12,C6:C11,0
This is the equivalent of the CASE function in other programming languages.
Points to byundt please, but I did want to post an alternative using the CHOOSE function that might be useful when the criteria set is greater than two conditions:
- if C12= C6, then "m2"
- if C12=C7, then "q9"
- if C12 = C8, then "lm"
- if C12 = C9, then "lmno"
- if C12 = C10 or C11, then "xyz"
=CHOOSE(MATCH(C12,C6:C11,0
This is the equivalent of the CASE function in other programming languages.