If formula

[dunmore83]

I have posted this previously but have not yet found the solution.

If cell D6 has any of the following text entries;

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

Then I need this formula to execute in cell J6

=IF(G6="BUY",(H6-I6)*10000,(I6-H6)*10000)

However, if these text entries appear in cell D6;

USD / JPY
GBP / JPY
EUR / JPY
CHF / JPY
CAD / JPY
AUD / JPY
NZD / JPY
XAU / USD
XAG / USD

Then I need this formula to execute;

=IF(F6="BUY",(G6-H6)*100,(H6-G6)*100)

Thanks!!

 

[dunmore83]

Correction. Last formula should have read;

=IF(G6="BUY",(H6-I6)*100,(I6-H6)*100)

 

[VoG]

Continuation of http://www.mrexcel.com/forum/showthread.php?644808-If-function

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).