Hi, kind of new with doing complicated functions in Excel but I got the Error Message:
Anyway here's my code:You've entered too many arguments for this function.
To get help with this function, click OK to close this message. Then click the Insert Function button located to the left of the equal sign in your formula.
I'm basically trying to do 4 calculations:=IF(AND(C11="USD/JPY",D11="Long"),(G11-F11)*100,IF(AND(C11="USD/JPY",D11<>"Long"),(F11-G11)*100),IF(AND(C11<>"USD/JPY",D11="Long"),(G11-F11)*10000),IF(AND(C11<>"USD/JPY",D11<>"Long"),(F11-G11)*10000))
- USD/JPY Long
- USD/JPY Short
- Not USD/JPY Long
- Not USD/JPY Short
Any help would be very useful. Thanks!
Bookmarks