IF Function with Multiple Criteria

[excel_learner]

No still it does not work for last formula where it is equal to 14 and it is excluded in first match, returns 0.

[Admin]

Hi

Can you attach a sample workbook with some dummy values along with expected results ?

[excel_learner]

sample is attached and hope i have made it clear.

[Admin]

Hi

I think this is the formula you want.

=IF(AND(ISNA(MATCH(A3,pc_cc,0)),ISNA(MATCH(C3,coun ,0))),IF(AND(A3<>14,B3>=$E$1,B3<=$F$1),(D3*2065375 0)/172884227,IF(AND(A3=14,B3>=$E$1,B3<=$F$1),(D3*1500 30)/6083342,0)),0)

and if you evaluate this formula

first it checks

AND(ISNA(MATCH(A3,pc_cc,0)),ISNA(MATCH(C3,coun,0)) )

if it evaluates TRUE, the next step

IF(AND(A3<>14,B3>=$E$1,B3<=$F$1)

.. and if it evaluates TRUE, then it calculates (D3*20653750)/172884227

or if it evaluates FALSE, then evaluates this one.. IF(AND(A3=14,B3>=$E$1,B3<=$F$1)

If it TRUE, (D3*150030)/6083342, otherwise 0

Is it what you are after ?

if not, give me the cell values for E3:E18.

[excel_learner]

I have attached sample data with required values;

Kindly see.

[Admin]

Hi,

In E7, this ISNA(MATCH(A7,pc_cc,0)) returns FALSE.

[excel_learner]

Ok, any way out to get correct values. But this works fine if I dont put the second match which excludes coun.