Hi... sorry if this is complicated. I am not expecting it to be possible but would be very happy if there was a solution!!
Currently CELL J6 contains this formula;
=IF(F6="BUY",(G6-H6)*100,(H6-G6)*100)
This is based on cell F6 containing the text "BUY" or "SELL".
My situation is I need to expand this function by also searching cell D6. If cell D6 contains any text other than "JPY" then the formula in J6 needs to be;
=IF(G6="BUY",(H6-I6)*10000,(I6-H6)*10000)
If you need any more clarification please let me know.
Thanks
Currently CELL J6 contains this formula;
=IF(F6="BUY",(G6-H6)*100,(H6-G6)*100)
This is based on cell F6 containing the text "BUY" or "SELL".
My situation is I need to expand this function by also searching cell D6. If cell D6 contains any text other than "JPY" then the formula in J6 needs to be;
=IF(G6="BUY",(H6-I6)*10000,(I6-H6)*10000)
If you need any more clarification please let me know.
Thanks