Solved

if statement "m2" or "lm"- excel 2010

Posted on 2013-05-09
6
232 Views
Last Modified: 2013-05-21
hi experts, id like some help with the following formula

=if(or(c12=c6,c12=c7),"m2",if(c12=c8,c12=c9,c12=c10,c12=c11),"lm",""))

basically if c12= c6 or c7 then show "m2" and if c12 = c8, c9, c10 or c11 then show "lm"
0
Comment
Question by:FrankSasso
6 Comments
 
LVL 81

Assisted Solution

by:byundt
byundt earned 110 total points
ID: 39154454
=IFERROR(IF(MATCH(C12,C6:C11,0)<3,"m2","lm"),"")
0
 

Author Comment

by:FrankSasso
ID: 39154514
hi byundt, i tried this formula but it did not work
0
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 165 total points
ID: 39154531
=if(or(c12=c6,c12=c7),"m2",if(or(c12=c8,c12=c9,c12=c10,c12=c11),"lm",""))
0
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39154828
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?
0
 
LVL 81

Expert Comment

by:byundt
ID: 39155045
Please post a sample workbook that demonstrates the formula not working.
0
 
LVL 10

Expert Comment

by:mark_harris231
ID: 39155172
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),"m2","q9","lm","lmno","xyz","xyz")

This is the equivalent of the CASE function in other programming languages.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question