If Function

[jcc31]

Can someone tell what I'm doing wrong here. Here is my file.

Oh, also is there way on the first line to have excel search for null and spaces at the same time?

Thanks a million

[Chip Pearson]

Few people will open attachments, due to the possibility of
harmful code. Describe your problem clearly in your message and
someone will be able to answer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jcc31" <jcc31.20b5an_1135030202.6957@excelforum-nospam.com>
wrote in message
news:jcc31.20b5an_1135030202.6957@excelforum-nospam.com...
>
> Can someone tell what I'm doing wrong here. Here is my file.
>
> Oh, also is there way on the first line to have excel search
> for null
> and spaces at the same time?
>
> Thanks a million
>
>
> +-------------------------------------------------------------------+
> |Filename: IF.zip
> |
> |Download: http://www.excelforum.com/attachment.php?postid=4132
> |
> +-------------------------------------------------------------------+
>
> --
> jcc31
> ------------------------------------------------------------------------
> jcc31's Profile:
> http://www.excelforum.com/member.php...o&userid=24692
> View this thread:
> http://www.excelforum.com/showthread...hreadid=494725
>

[Leith Ross]

Hello Jcc31,

Your Formula should look like this...
=IF(F:F="", CONCATENATE(D1, "", E1), CONCATENATE(D1, "", E1, "APT, F1))

An alternate way to using CONCATENATE is this...
D1 & "" & E1

You should be aware that this test will only be TRUE when the cell in same row as the Formula in Column F is empty.

Example:
Formula is in cell C4. The formula check cell F4 to see if it empty. The Formula doesn't scan the entire range to see if it is empty. If you want the result in C4 to return true when all of column F is empty, you will need to check this differently.

In answer to question about checking both null and spaces at the same time, the answer is no. You have to check for each condition individually.

Sincerely,
Leith Ross

[Toppers]

Hi,
Remove the "=" from the concatenate statements.

"jcc31" wrote:

>
> Can someone tell what I'm doing wrong here. Here is my file.
>
> Oh, also is there way on the first line to have excel search for null
> and spaces at the same time?
>
> Thanks a million
>
>
> +-------------------------------------------------------------------+
> |Filename: IF.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4132 |
> +-------------------------------------------------------------------+
>
> --
> jcc31
> ------------------------------------------------------------------------
> jcc31's Profile: http://www.excelforum.com/member.php...o&userid=24692
> View this thread: http://www.excelforum.com/showthread...hreadid=494725
>
>