[FIXED] How to fix an a concatenate formula conditional to a non blank cell

Issue

I'm trying to concatenate cells from columns C, D & E as long as Cell A is not blank (has a value)

Cell A is a formula based on listing weekdays:

=IF(WORKDAY(A$28-1;ROW(21:21))>A$29;"";WORKDAY(A$28-1;ROW(21:21)))

My concatenate formula is as follows:

=IF(ISBLANK(A24);"";CONCATENATE(E24;CHAR(10);D24;CHAR(10);C24))

The formula is still concatenating even if Cell A is blank

snapshot of excel

Solution

Blank

Blank (Empty Cell) means 'nothing' inside the cell, no formula no value i.e. a cell containing an Empty String ("") is not blank. As soon as you have put a formula or any value into a cell, it isn't blank anymore.

You should use this formula:

=IF(A24="";"";CONCATENATE(E24;CHAR(10);D24;CHAR(10);C24))

where A24="" includes blank cells, so you don't have to use ISBLANK, too.

Answered By - VBasic2008

Answer Checked By - Marie Seifert (PHPFixing Admin)