nested if questions

[congokin]

how can i combine these 3 if statements into 1

<r2),"lowerwin","0")
<r2),"lowerwin","0")
<r2)),"upperwin-lowerwin","0")<r2)),"upperwin-lowerwin","0")
=if((k2>q2),"UpperWin","0")

=if((m2<r2),"LowerWin","0")

=if(and(k2>q2), and(m2<r2)),"UpperWin-LowerWin","0")


</r2)),"upperwin-lowerwin","0")<r2)),"upperwin-lowerwin","0")
</r2),"lowerwin","0")
</r2),"lowerwin","0")

 

[Michael M]

Your 3rd statement is incomplete...if you are using < or > signs put a space between each one before posting

 

[congokin]

2nd statement
if((m2 < r2),"LowerWin","0")

3rd statement
if(and(k2 > q2), and(m2 < r2)),"UpperWin-LowerWin","0")<r2),"lowerwin","0")< html=""></r2),"lowerwin","0")<>

 

[Michael M]

Still not making any sense....Is that ALL of the statements ??

 

[congokin]

basically this is a bracket trade.
if the high of today (k2) is higher then the upper boundary of the bracket (q2) = Win
if the low of today (m2) is lower than lower boundary of the bracket (r2) = Win
if the high of today is higher of then the upper boundary of the bracket trade + if the low of today is lower than lower boundary of lower Trade = Win

I have each statement in 3 different col but want to have them in 1

 

[Michael M]

MAybe this then

=IF(K2>Q2,"UpperWin",IF(M2 < R2,"LowerWin",IF(AND(K2>Q2,M2 < R2),"UpperWin-LowerWin",0)))

 

[congokin]

MAybe this then

=IF(K2>Q2,"UpperWin",IF(M2 < R2,"LowerWin",IF(AND(K2>Q2,M2 < R2),"UpperWin-LowerWin",0)))

thanks Michael M, but the formula does not work quite right
IF(AND(K2>Q2,M2 < R2),"UpperWin-LowerWin" - this part does not give me "UpperWin-LowerWin"

 

[congokin]

but this is working
=IF(AND(K2>Q2,M2 < R2),"UpperWin-LowerWin",IF(K2>Q2,"UpperWin",IF(M2 < R2,"LowerWin",0)))
thanks again

 

[Michael M]

The difference between the formulas, is simply which argument you wanted first ??

 

[congokin]

The difference between the formulas, is simply which argument you wanted first ??

yes, that is right...I was wrong in the order in my argument...thanks again...Problem solved