Cannot figure out what I am doing wrong

[BokiB]

Hey,

I have this formula and I cannot figure out what I am doing wrong:

=IF(AND(E3="Australia";I3="Canada");'Exchange rates'!E2); IF(AND(E3="Australia";I3="New Caledonia");'Exchange rates'!M2))

Am I missing a bracket somewhere, or something else I am doing wrong?

Thanks for your help!

 

[xld]

It is not the maximum number of IF statements, it is the maximum number of NESTED functions that is relevant, and this barrier has been removed in Excel 2007.

For instance,
=IF(A1=10,"Yes",IF(A1=17,"Maybe",...
is just one nested function. Whereas,
=IF(A1=10,"Yes","")&IF(A1=17,"Maybe","")&...
is no nested functions (a bit of a crass example, but hopefully you get the point.

If you have 33 conditions to test, it would probably be better to have a lookup table, and check against that.