We help IT Professionals succeed at work.

Using IF and ISBLANK in Excel Formula

JudithARyan
JudithARyan asked
on
I'm try to concatenate some columns in an Excel worksheet and keep get the #NAME? result or it complains about parentheses.

Col B = Name Prefix
Col C = First Name
Col E = Last Name
Col G = Spouse Name Prefix
Col H = Spouse First Name

=IF(ISBLANK(H9),(B9 & " " & C9 & " " & E9),((B9 & And & G9) & (C9 & And & H9) & (" " & E9)))

Any idea of what I'm doing wrong?  The True formula works fine, but when I put it together with the rest, it falls apart!

Thanks for your help.
Comment
Watch Question

=IF(H9="",B9 & " " & C9 & " " & E9,B9 & G9 & C9 & H9 & " " & E9)

gowflow
looking at it you want this
=IF(H9="",B9 & " " & C9 & " " & E9,B9 & " and " &  G9 & " " & C9 & " and " & H9 & " " & E9)

gowflow