Two-condition If formula

You have to many nested functions... Excel 2003 and earlier only allow up to 7 nested functions...

You can try creating 7 separate IFs and add the results... they should all return 0 except for the one that has the right combo...so when added together you should get the correct result...

Try:

=IF(AND(B3="EURCHF",C3="Sell"),D3-J17,0)+IF(AND(B3="EURCHF",C3="Buy"),D3+J17,0)+IF(AND(B3="EURGBP",C3="Sell"),D3-J13,0)+IF(AND(B3="EURGBP",C3="Buy"),D3+J13,0)+IF(AND(B3="EURJPY",C3="Sell"),D3-J19,0)+IF(AND(B3="EURJPY",C3="Buy"),D3+J19,0)+IF(AND(B3="USDCHF",C3="Sell"),D3-J15,0)+IF(AND(B3="USDCHF",C3="Buy"),D3+J17,0)