Forum Discussion

Copper Contributor

Jan 22, 2018

Solved

IF Statement for Multiple conditions

Dear Friends, Could anyone look into my doubt and provide the solution..! Thanks S.No Name Input Result 1 ABC Yes/No ? 2 BCD Yes/No 3 ...

Jan 23, 2018

Assume S.No in A1 cell, Name in B1 cell, Input in C1 cell, and so on.

Excel 2016

in cell F2

=SWITCH(SUMPRODUCT(--($C$2:$C$6="Yes"),{1;2;4;8;16}),3,"Good",28,"OK",26,"Not Good",17,"Fine",11,Average,"?")

Excel 2013 or below

create a name in name manager, called TheValue

=SUMPRODUCT(--($C$2:$C$6="Yes"),{1;2;4;8;16})

in cell F2

=IF(TheValue=3,"Good",IF(TheValue=28,"OK",IF(TheValue=26,"Not Good",IF(TheValue=17,"Fine",IF(TheValue=11,"Average","?")))))

Iron Contributor

Jan 22, 2018

Condition 4 never happens. Fine result never comes out.

Copper Contributor

Jan 23, 2018

Condition 4 is corrected. Could you look into it again...!

Thanks