Nested If Statement - Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the below If statement, which is working fine expect that when both
column K and L = blank (satisfying false criteria) it returns "CCO". If both
columns are blank I do not want a value returned. How do I insert another If
statement (or maybe an ISBLANK???) to make sure if both are blank nothing is
returned?

IF(OR(K10="Value1",K10="Value2", K10="Value3",L10= "Value4")),("CCT"),("CCO"))

Thanks in advance!
 
=IF(OR(K10="Value1",K10="Value2",K10="Value3",L10="Value4"),"CCT",IF(AND(K10="",L10=""),"","CCO"))
 
And losing some of those K10s

=IF(OR(K10={"Value1","Value2","Value3"},L10="Value4"),"CCT",IF(AND(K10="",L10=""),"","CCO"))
 
Thank you so much for the more efficient formula - I had figured it out with
this
=IF(M10&N10="","",IF(OR(K10="Value1)",K10="Value2",K10="Value3",L10="Value4"),("CCT"),("CCO")))

Your way is much better and shorter - thanks for the help :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nested if 6
Changing Sum Range Based on Date Chosen from Drop Down List 1
IF and ISBLANK 4
Nested IF problem - help please 11
Nested IF Statements 6
Nested IF 2
Nested If/And/Or statements 4
Help with Nested IF Statements 4

Back
Top