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")

<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")

Last edited: