Solved

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

Posted on 2013-05-09
6
233 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:Frank .S
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:Frank .S
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

733 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