excel - Excel If and else statement

Question

Hi All,

Can somebody please help me with if and else in excel.

My codes seems correct when doing it separately, but when combining them - it does not work.

Codes are as follow:

=IFS(E7=Sheet2!$B$4,Sheet2!$C$4,IF(E7=Sheet2!B5,Sheet2!$C$5,"10"),IF(E7=Sheet2!$B$11,Sheet2!$C$11,IF(E7=Sheet2!B12,Sheet2!C12,Sheet2!C13)))

the last option still give me #value error.

have the sheet 2 that includes:

Merit Score
Low    2
Medium 5  
High  10   

Error   Score
Low   -2 
Medium -4
High -10

标签： excelif-statement

Answer 1

The begining of the code is wrong. See if this works.

Wrong

=IFS(IFE7=Sheet2!$

Right

=IFS(E7=Sheet2!$

Regards