title: Excel If and else statement
body: <p><img src="https://i.stack.imgur.com/QSDDd.png" alt="enter image description here"></p>
  
  <p>Hi All,</p>
  
  <p>Can somebody please help me with if and else in excel.</p>
  
  <p>My codes seems correct when doing it separately, but when combining them - it does not work.</p>
  
  <p>Codes are as follow:</p>
  
  <pre><code>=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)))
  </code></pre>
  
  <p>the last option still give me #value error. </p>
  
  <p>have the sheet 2 that includes:</p>
  
  <pre><code>Merit Score
  Low    2
  Medium 5  
  High  10   
  
  Error   Score
  Low   -2 
  Medium -4
  High -10
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/XRPex.png" alt="enter image description here"></p>