=IF(D6<>"jpy",IF(G6="buy",(H6-I6)*100,(I6-H6)*100),IF(G6="buy",(H6-I6)*10000,(I6-H6)*10000))

Cell G6 is a text cell which contains either "BUY" or "SELL". If BUY then (H6-I6) / If SELL then (I6-H6)

The formula is then based on cell D6 which is also a text cell. If cell D6 contains the following text entries then the formula needs mulitply by 1000 i.e IF(G6="buy",(H6-I6)*10000,(I6-H6)*10000)

EUR / USD

GBP / USD

AUD / USD

NZD / USD

USD / CHF

USD / CAD

GBP / CHF

GBP / CAD

GBP / NZD

GBP / AUD

EUR / GBP

EUR / CHF

EUR / CAD

EUR / NZD

AUD / CHF

AUD / CAD

AUD / NZD

CAD / CHF

However if the following text entries are found in cell D6 then the formula needs to multiply by 100 i.e. IF(G6="buy",(H6-I6)*100,(I6-H6)*100)

USD / JPY

GBP / JPY

EUR / JPY

CHF / JPY

CAD / JPY

AUD / JPY

NZD / JPY

XAU / USD

XAG / USD

Alternatively the formula could just be based on the discrepancy in the text entries in the cells i.e. if JPY or XAU or XAG is found in cell D6 then *100 / if these text entries are not found *1000.

Thanks!!