Nesting 2 completely different IF statements?

[kvmike]

Hi,

Hoping someone can help me.
Currently i have 2 separate IF statements checking for separate conditions:

First one checks if 1 cell is blank, and a corresponding one isn't and will result in a string of text:
=IF(OR(ISBLANK(H2<>""),ISBLANK(A2)),"No Deal Reg - Contact Opportunity Owner","")

Second one checks if 2 statement conditions align in a specific way and will provide a result based on this:
=IF(AND(OR(E12={"Rejected","Expired"}),OR(F12={"Quoting","Not Qualified","Quoted"})),"Review status with Supplier","")

Can anyone see a way that i can merge these into a formula for 1 cell? rather than using 2 different cells.

Many thanks in advance

 

[jasonb75]

The simplest way to do it is like this, although whether or not that will suit your requirements is an entirely different matter. Given that you have 2 entirely different sets of criteria it may be necessary to change the order of the different parts depending on which criteria has priority if multiple conditions are met.

=IF(OR(ISBLANK(H2<>""),ISBLANK(A2)),"No Deal Reg - Contact Opportunity Owner",IF(AND(OR(E12={"Rejected","Expired"}),OR(F12={"Quoting","Not Qualified","Quoted"})),"Review status with Supplier",""))

If you want the results of both formulas to be shown if both sets of criteria are met then you should really be using 2 cells. Whilst possible in a single cell it would not be considered a good idea.

 

[kvmike]

The simplest way to do it is like this, although whether or not that will suit your requirements is an entirely different matter. Given that you have 2 entirely different sets of criteria it may be necessary to change the order of the different parts depending on which criteria has priority if multiple conditions are met.

=IF(OR(ISBLANK(H2<>""),ISBLANK(A2)),"No Deal Reg - Contact Opportunity Owner",IF(AND(OR(E12={"Rejected","Expired"}),OR(F12={"Quoting","Not Qualified","Quoted"})),"Review status with Supplier",""))

If you want the results of both formulas to be shown if both sets of criteria are met then you should really be using 2 cells. Whilst possible in a single cell it would not be considered a good idea.

Perfect thank you! this will work fine for 1 cell as there will never be a scenario where to 2 different IF statement criteria clash. Thanks again