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","?")))))

Copper Contributor

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

Thanks

Steel Contributor

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","?")))))

Forum Discussion