title: Excel if formula
body: <p>Below are the result that I want to have, basically I want B1 to B4 can automatically detect string from A1 to A4 and return same string plus the severity level when match the string.</p>
  
  <p>For example, if A1= Critical, B1 should display Critical Severity 1
  and if A1 changed to High, B1 should display High Severity 2</p>
  
  <p>Current I'm using </p>
  
  <pre><code>=IF(A1="Critical","Critical Severity 1",""),IF(A1="High","High Severity 2",""),IF(A1="Medium","Medium Severity 3",""),IF(A1="Low","Low Severity 4","")
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/bxkek.png" alt="enter image description here"></p>