IF Function with Multiple Criteria

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

Hi

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

sample is attached and hope i have made it clear.

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.

I have attached sample data with required values;

Kindly see.

Hi,

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

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