I am using this formula

Formula1
=IF(ISNA(IF(OR(ISNA(C2);D2=2);"";A1));"";IF(OR(ISN A(C2);D2=2);"";A1))

C2 has the following formula:

=A1&$B$1

If the conditions of Formula1 are true, the result seems to diplay the A1
value, not the concatentated value A1&$B$1.

Is there a way to modify Formula1 to display the concatenated value ?

Thank you in advance.