Quote Originally Posted by NBVC View Post
Perhaps:

=IF(F2="Long",K2-H2,H2-K2)*IF(RIGHT(D2,3)="JPY",100,10000)
NBVC that's the ticket! Your help is very much appreciated. Thank you!