title: Multiple if statements to chose particular cell in Excel
body: <p>I am trying to  write an IF statement that will chose a certain cell based on the contents on multiple other cells. </p>
  
  <p>Essentially what I want to happen in cell Y2 is:</p>
  
  <p>If X2 is &lt;0 Then Y2=X2.</p>
  
  <p>If X2 is >0 Then Y2=X2 BUT only if X2 &lt; V2</p>
  
  <p>If X2 is >0 AND >V2 Then Y2 = V2 </p>
  
  <p>What I have is the below but, it doesn't work</p>
  
  <p>=IF(AND(X2&lt;0),X2,IF(X2>0,X2,IF(X2>V2,V2)))</p>
  
  <p>Thanks in advance </p>