Combining concatenate and if in Excel formulas

excel, excel-2007, excel-formula

Solution

Maybe you're looking for this instead?

=CONCATENATE(IF(ISBLANK('Unapplied Report'!A5),"",TEXT('Unapplied Report'!A5,"0000")),
             IF(ISBLANK('Unapplied Report'!C5),"",TEXT('Unapplied Report'!C5,"000")),
             IF(ISBLANK('Unapplied Report'!D5),"",TEXT('Unapplied Report'!D5,"0000")))

This will concatenate only those cells that are not blank.

Problem

How would I add the `IF(ISBLANK` formula to this formula ``` =CONCATENATE(TEXT('Unapplied Report'!A5,"0000"),TEXT('Unapplied Report'!C5,"000"),TEXT('Unapplied Report'!D5,"0000")) ``` without getting any errors. I've tried it a couple times and just get formula error messages.

Original source