#### FreshlySqueezed

##### New Member

- Joined
- Sep 22, 2019

- Messages
- 10

1 row:

$X1

$Y1

$Z1

If there's a number in any of these, l want to trigger a concatenation involving the data in that specific cell.

The row will be filled in left to right. So, if X1 is empty, then Y1 and Z1 will be too.

If Y1 is empty, then Z1 will be empty too, but X1 may have data.

If Z1 is empty, then X1 and Y1 may have data

Typical data:

01 05 07 ---> Desired output: Cobalt - Day 01, Cobalt - Day 05, Cobalt - Day 07

Another example:

03 12---> Desired output: Cobalt - Day 03, Cobalt - Day 12

Formula l've been trying:

=IF(ISNUMBER($Z1),concatenation formula that includes data in x1 and y1 and z1,

IF(ISNUMBER($Y1),concatenation formula that includes data in x1 and y1 only,

concatenation formula for x1 only

)

)

Or alternatively, for the final "or else", i would add if X1 is a number, then just give the concatenation formula for x1 only, otherwise just state ""

BUT: None of this is working. I'm using LibreOffice in Excel 2003 mode. I know it's a very old version and l could easily go for a higher version emulation but please, what am l doing wrong?

This should be a no-brainer for me. I thought l knew nested IFs. Apparently it's done differently now though? But l tried a suggested alternative, where l have complete self contained IFs, in serial, but that didn't work either.