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.