I have three columns (col1, col2, and col3) which I need to use a nested formula to output into col4.

The logic is as follows:

• IF col3 = Yes AND IF (col1 = col2) THEN Sales Opportunity
• IF col3 = Yes AND IF (col1 <> col2) THEN Partner Opportunity
• IF col3 = No THEN ""

So far I've put together a combination of different formulas, none of which seem to create any meaningful results. Two of the following examples:

=IF(AND(AX28="Yes",F28=D28),"CLM Opportunity"),IF(AND(AX28="Yes",F28<>D28),"Partner Opportunity","")

=IF(OR(AND(AX35="Yes",F35=D35),AND(AX35="Yes",F35<>D35)),"CLM Opportunity","Partner Opportunity")

How the nested formulas should output:

Any help is greatly appreciated!

CodePudding user response：

Use a nested IF:

=IF(C2="Yes",IF(A2=B2,"Sales Op","Partner Op"),"")

Logic: