Originally posted by: SJacob

Hi,

Is there a way to do Nested IF's or When conditional statements in the Map ?

Any examples is greatly appreciated.

Thanks,

SJacob

Originally posted by: Ejay

Hi ,

I think you are looking for the EITHER function .

http://www.ibm.com/support/knowledgecenter/SSVSD8_8.4.1/com.ibm.websphere.dtx.funcexp.doc/references/r_funcs_express_EITHER.htm?lang=en

EJ

Originally posted by: paul.brett

An IF where both the conditions have to be true:

=IF(In1="A",IF(In2=42,"BOTH TRUE","Input 1 is A, but Input 2 is not 42"),"Input 1 is not A (additional conditions may not be met)")

An IF where either of the conditions can be true:

=IF(In1="A","A TRUE",IF(In2=42,"42 TRUE"))

...or the same thing done with an EITHER() which can be helpful if evaluating lots of conditions:

=EITHER(IF(In1="A","A TRUE"),IF(In2=42,"42 TRUE"))

Thank-you.

Paul

Follow me on Twitter

Originally posted by: SJacob

Thank You very much. Both the options helped.