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!
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!