SOLVED

TEXT IN EXCEL FORMULA

Highlighted
New Contributor

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.

3 Replies
Highlighted
Best Response confirmed by JahDiel (New Contributor)
Solution

@JahDiel 

 

How about this?

 

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

@Subodh_Tiwari_sktneer 

 

THANK YOU VERY MUCH. 

 

Highlighted

You're welcome @JahDiel!