title: 3 conditions with nested if and AND function in Excel
body: <p>Iam simply trying categories some values, if satisfies some conditions.</p>
  
  <p><img src="https://i.stack.imgur.com/gMWmI.png" alt="this is my need"></p>
  
  <p>if a student get mark according to the plan , I need to show correspond plan.</p>
  
  <p>like this,</p>
  
  <p>if the student satisfies plan 1 condition,
  Result want to be Plan1</p>
  
  <p>if the student satisfies plan 2 condition,
  <img src="https://i.stack.imgur.com/MdGol.png" alt="enter image description here"></p>
  
  <p>if the student didn't meet above 2 conditions, then show "NO PLAN"</p>
  
  <p>I used this formula,</p>
  
  <pre><code>=IF(AND(H86&gt;=200,Q86&gt;=250,Y86&gt;=14,AD86&gt;=17,AI86&gt;=18,AN86&gt;=18),"Plan 1",IF(OR(H86&gt;=180,H86&lt;200,Q86&gt;=225,Q86&lt;250,Y86&gt;=13,Y86&lt;14,AD86&gt;=15,AD86&lt;17,AI86&gt;=16,AI86&lt;18,AN86&gt;=16,AN86&lt;18),"Plan 2","NO Plan"))
  </code></pre>
  
  <p>In this formula, the 2nd if contains 2 conditions, if the mark is between plan 1 and plan 2 we need show Plan 2 also if mark is greater than and equal to plan 2 , we need to show Plan2. here iam stuck. </p>