Multiple If Conditions

[Amit Gandhi]

Hi All

Pls see attached sample file.

1. Data Set in C2 : M2
2. Condition Table in B6 : M9

I have calculated required result in cell N13, by applying several If formulas(similar) in cells C13 to M13

If possible, I need one single excel formula in cell N2 to get same result as in cell N13.

Please help me here. It will save my lot of time.

Regards

Amit

 

[John Jairo V]

Hi, @Amit Gandhi!

You can try this formula:
[N2] : =SUMPRODUCT((C2:M2<C6:M9)*(C5:M5="<")+(C2:M2>C6:M9)*(C5:M5=">"))

Blessings!

 

[Amit Gandhi]

Hi, @Amit Gandhi!

You can try this formula:
[N2] : =SUMPRODUCT((C2:M2<C6:M9)*(C5:M5="<")+(C2:M2>C6:M9)*(C5:M5=">"))

Blessings!

Thanks Sir, you saved my lot of time. Thanks for your help.