If both B4 and D4 are blank write 'this' if either B4 or D4 have values concatenate

**Greenal** · 08-22-2011, 08:13 AM

Hello,

I'm trying to complete the following

"If both B4 and D4 are blank write 'this' if either B4 or D4 have values concatenate the values with a pipe separator"

Any help greatly appreciated.

Thanks.

**Colin Legg** · 08-22-2011, 08:16 AM

Hi,

Try this:

Please Login or Register  to view this content.

**Greenal** · 08-22-2011, 08:51 AM

Originally Posted by Colin Legg

Hi,

Try this:

Please Login or Register  to view this content.

Hi Colin,

Thanks for your reply.

I've tried your formula - the 'ISBLANK' part is leaving the cell with a | when B4 and D4 are empty. When B4 and D4 are populated it's working well...

**Colin Legg** · 08-22-2011, 09:00 AM

Hi,

Then I suspect that B4 and D4 are not truly empty... do you have formulae in those cells which return a null string? If so, try this instead:

Please Login or Register  to view this content.

**Greenal** · 08-22-2011, 09:42 AM

Originally Posted by Colin Legg

Hi,

Then I suspect that B4 and D4 are not truly empty... do you have formulae in those cells which return a null string? If so, try this instead:

Please Login or Register  to view this content.

You suspect correctly

Sorry for not spelling that out, the above formula works perfect.

Many thanks

If both B4 and D4 are blank write 'this' if either B4 or D4 have values concatenate

LinkBack

Thread Tools

Rate This Thread

Display

If both B4 and D4 are blank write 'this' if either B4 or D4 have values concatenate

Re: If both B4 and D4 are blank write 'this' if either B4 or D4 have values concatena

Re: If both B4 and D4 are blank write 'this' if either B4 or D4 have values concatena

Re: If both B4 and D4 are blank write 'this' if either B4 or D4 have values concatena

Re: If both B4 and D4 are blank write 'this' if either B4 or D4 have values concatena

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions