nested if

[surajap123]

Hi All,

Please help me with the difference between both the expressions. Both give the same result then why additional brackets??

=IF(Name='John','Male',if(Name='Mary','Female','N/A'))

=IF(Name='John','Male',(if(Name='Mary','Female','N/A')))

Thanks!!

[#2 · Accepted solution]

Hi Suraj,

there is nothing to worry about that its just a way of representation, additional brackets show its a part of else.they both give same result

[its_anandrjs]

Hi,

NO difference in the both the expression but better you can use Mapping table here instead of the if condition if it is in any chart that ok. But you can do this in any load script.

Regards

Anand

[ecolomer]

Both are the same result the only difference are your representation

[surajap123]

Thanks everyone for the inputs !!