TEXT IN EXCEL FORMULA

[JahDiel]

Current excel formula excel reads the word "Buy or Close" and performs the calculation
eg: =IF(Close="","",IF(Action="Buy",Close-Entry,IF(Action="Sell",Entry-Close))*10000).
I want to add a column named Market.

If "Market" has JPY, as the first three letters in the cell (JPY/USD) or the last three (AUD/JPY), it then multiplies the formula by 100, if not then 10000.
Thanks in advance.

[#2 · Accepted solution]

@JahDiel 

How about this?

=IF(Close="","",IF(Action="Buy",Close-Entry,IF(Action="Sell",Entry-Close))*IF(ISNUMBER(SEARCH("jpy",Market)),100,10000))

[#3]

@Subodh_Tiwari_sktneer 

THANK YOU VERY MUCH. 

[#4]

You're welcome @JahDiel!