Thread: You've entered too many arguments for this function

Hi, kind of new with doing complicated functions in Excel but I got the Error Message:

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.

Anyway here's my code:

=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))

I'm basically trying to do 4 calculations:

1. USD/JPY Long
2. USD/JPY Short
3. Not USD/JPY Long
4. Not USD/JPY Short

Any help would be very useful. Thanks!

Misplaced parentheses?

Try:

=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,""))))