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