Modifying a formula to display the results of another formula
 

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.

Hi Carl

is this what you're after?
=IF(ISNA(IF(OR(ISNA(C2);D2=2);"";A1&$B$1));"";IF(O R(ISNA(C2);D2=2);"";A1&$B$1))CheersJulieD"carl" wrote in ...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.