Excel 2010 - Combining IF OR Statements

[Johnny Thunder]

Hello All,


Working on this formula and need help combining it with another IF/OR Statements.

= IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2), CONCATENATE(C14, "_", D14, "_",E14), "Non-Royalty")

I need two have the "Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2" portion of the formula change to "Other Dropdowns'!$C$3" in the second IF statement.

So i tried something like this but it resulted in an error:

= IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2), CONCATENATE(C14, "_", D14, "_",E14), "Non-Royalty"),= IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$3), CONCATENATE(C14, "_", D14, "_",E14), "Non-Royalty")


Any help would be much appreciated. Thanks again everyone!

 

[etaf]

I need two have the "Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2" portion of the formula change to "Other Dropdowns'!$C$3" in the second IF statement.

whats the condition

you have
IF ( test, true ,false ) here
= IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2), CONCATENATE(C14, "_", D14, "_",E14),"Non-Royalty")

so you cannot add
= IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$3), CONCATENATE(C14, "_", D14, "_",E14), "Non-Royalty")

I need two have the "Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2" portion of the formula change to "Other Dropdowns'!$C$3"
whats the conditions that apply to change from the
"Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2"
to use
"Other Dropdowns'!$C$3"

 

[Johnny Thunder]

So what I was trying to say is that this formula works for me now,

= IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2), CONCATENATE(C14, "_", D14, "_",E14), "Non-Royalty")

I need to replicate it 2 more time and some how combine it so

= IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$3), CONCATENATE(C14, "_", D14, "_",E14), "Non-Royalty") ****All I changed was "Other Dropdowns'!$C$3"****

= IF(OR(CONCATENATE(C14, "_", D14, "_",E14) =Logos&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$4), CONCATENATE(C14, "_", D14, "_",E14), "Non-Royalty") ****All I changed was "Other Dropdowns'!$C$4"****


And then somehow combine all three. Hope that clears it up better.

 

[kevatarvind]

something like below try

=IF(OR(C14&"_"&D14&"_"&E14="Logos"&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2,C14&"_"&D14&"_"&E14="Logos"&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$3),C14&"_"&D14&"_"&E14,"Non-Royalty")

 

[Johnny Thunder]

something like below try

=IF(OR(C14&"_"&D14&"_"&E14="Logos"&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$2,C14&"_"&D14&"_"&E14="Logos"&"_"&'Other Dropdowns'!$B$2&"_"&'Other Dropdowns'!$C$3),C14&"_"&D14&"_"&E14,"Non-Royalty")

Just kept returning "Non_Royalty". thanks for the help though.

 

[kevatarvind]

try below one

=IF(AND(C14="Logos",D14='Other Dropdowns'!$B$2,OR(E14='Other Dropdowns'!$C$2,E14='Other Dropdowns'!$C$3,E14='Other Dropdowns'!$C$4)),C14&"_"&D14&"_"&E14,"Non-Royalty")

 

[Johnny Thunder]

try below one

=IF(AND(C14="Logos",D14='Other Dropdowns'!$B$2,OR(E14='Other Dropdowns'!$C$2,E14='Other Dropdowns'!$C$3,E14='Other Dropdowns'!$C$4)),C14&"_"&D14&"_"&E14,"Non-Royalty")

Worked perfectly!! I should have mentioned that "Logo" is actually LOGO (Named Range). But it worked out perfectly! thanks

 

[kevatarvind]

Thanks For The Feedback

Your Welcome

 

[Johnny Thunder]

Just a quick question, in the section in BOLD can you add as many rules as you want in there? like if I wanted to add 2 more "

"E14='Other Dropdowns'!$C$3" with another Column "C" cell? Like C4 or C5?

=IF(AND(C14="Logos",D14='Other Dropdowns'!$B$2,OR(E14='Other Dropdowns'!$C$2,E14='Other Dropdowns'!$C$3,E14='Other Dropdowns'!$C$4)),C14&"_"&D14&"_"&E14,"Non-Royalty")

 

[kevatarvind]

Yes You Can Add

Try your self To do That

and if facing problem then let me know