Please can someone help with a Forex Type Spreadsheet

[pricey75]

Hi,

Please can some help, I am trying to write a formula in Excel to work out Stop Loss/Take Profit etc

However depending on Pairs traded the formula is a little different

Trying to "use if cell contains" JPY for Japanese Yen then multiply by 0.20 if not contains JPY then multiply by 0.0020, there are 28 diffent pairs so just want it to look for string JPY if possible

Struggling to get it work

Thanks in advance.

See sheet attached, i have managed to get it to work on different sheets but trying to combine if possible to a master sheet