IF Formula not screening the result of =cell&cell

[Ana Wisbeck]

Hello everyone!

i have a list of two columns with long IF formulas and I would like to merge the results of these columns and format it. I do not know how many results I will get so I have a few extra cells with formulas returning Blank values if there is no data.
Here's an example:

Name Surname Final Format
John Smith (Smith, John) ----> ="("&B1&", "&A1"&")"
Jane Doe (Doe, Jane)
( )
So when i drag the ="("&B1&", "&A1"&")" formula down if the values are blank I get ( ). I would like this cell to be blank as well. I have tried =if("("&B1&", "&A1"&")"="( )"," ","("&B1&", "&A1"&")") and that does not work.

Any other suggestions on how I can get this done?

Thanks a lot in advance!

Ana

 

[Aladin Akyurek]

Hello everyone!

i have a list of two columns with long IF formulas and I would like to merge the results of these columns and format it. I do not know how many results I will get so I have a few extra cells with formulas returning Blank values if there is no data.
Here's an example:

Name Surname Final Format
John Smith (Smith, John) ----> ="("&B1&", "&A1"&")"
Jane Doe (Doe, Jane)
( )
So when i drag the ="("&B1&", "&A1"&")" formula down if the values are blank I get ( ). I would like this cell to be blank as well. I have tried =if("("&B1&", "&A1"&")"="( )"," ","("&B1&", "&A1"&")") and that does not work.

Any other suggestions on how I can get this done?

Thanks a lot in advance!

Ana

Try something like...

=IF(A1&B1="","","("&B1&", "&A1"&")")

 

[Ana Wisbeck]

Oh, that was such a simple one! Works beatifully. I tried so many combinations before asking but I guess I missed out that one.

thanks so much!

Ana

 

[Aladin Akyurek]

Oh, that was such a simple one! Works beatifully. I tried so many combinations before asking but I guess I missed out that one.

thanks so much!

Ana

You are welcome. Thanks for providing feedback.