jeudi 5 mars 2015

Multiple if statements to chose particular cell in Excel

I am trying to write an IF statement that will chose a certain cell based on the contents on multiple other cells.


Essentially what I want to happen in cell Y2 is:


If X2 is <0 Then Y2=X2.


If X2 is >0 Then Y2=X2 BUT only if X2 < V2


If X2 is >0 AND >V2 Then Y2 = V2


What I have is the below but, it doesn't work


=IF(AND(X2<0),X2,IF(X2>0,X2,IF(X2>V2,V2)))


Thanks in advance


Aucun commentaire:

Enregistrer un commentaire