Combining Two Formulas

Hi All,

For some reason unknown to me; I cannot combine these two formulas below.
Every time I get a result for BUY Stop and BUY Limit it shows a number but the SELL Limit and SELL Stops show "FALSE" and do not calculate.

Full Formula:

=IF(E2="BUY",IF(F2="Stop",((G2-K2)/K2),(IF(E2="BUY",IF(F2="Limit",(-(G2-K2)/K2)),IF(E2="SELL",IF(F2="Stop",(-(G2-K2)/K2),(IF(E2="SELL",IF(F2="Limit",((G2-K2)/K2)),"ERROR"),"ERROR"),"ERROR"),"ERROR"),"ERROR"),"ERROR"),"ERROR"),"ERROR")

Individual Formulas to create the full formula (these work individually):

=IF(E2="BUY",IF(F2="Stop",((G2-K2)/K2),(IF(E2="BUY",IF(F2="Limit",(-(G2-K2)/K2)),"ERROR"))))
=IF(E2="SELL",IF(F2="Stop",(-(G2-K2)/K2),(IF(E2="SELL",IF(F2="Limit",((G2-K2)/K2)),"ERROR"))))

Cheers.

maybe this:

=IF(ISERR(1/K2),"Error",IF(E2="Buy",1,-1)*IF(F2="Limit",-1,1)*(G2-K2)/K2)

Upper solution consider that if it's not BUY then it's SELL... Also, if it's not LIMIT then it's STOP.
But if you want to consider all 4 solutions (there can be other words in cells and you need to return ERROR) then you can do something like:

=IFERROR(SIGN(MATCH(E2&F2,{"BuyLimit","SellStop","BuyStop","SellLimit"},0)-2,5)*(G2-K2)/K2,"ERROR")

Hi there. I don't believe this works. I think you've got a comma in the wrong place where the "5" is.