CODEWITHSUNDEEP
excelif-statementexcel-formulaconcatenationis-empty
Lou
Lou

Reputation: 31

How to fix an a concatenate formula conditional to a non blank cell

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

Upvotes: 1

Views: 319

Answers (1)

VBasic2008
VBasic2008

Reputation: 54807

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.

Upvotes: 1

Related Questions