'IF' Statement for a Concaterate Formula

[addie]

Hi,

I need an "IF" function for the concaterate formula that I'm working on below:

Reference Element Consolidation
222 10000 22210000 CORRECT
10000 10000 WRONG

The consolidation field can only be populated with characters if both the reference and element fields are populated. If either 'Reference' or 'Element' is missing characters, the consolidation field must be not be populated with any characters. It must simply read 'false' or 'blank'.

Thanks.

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>

[bj]

try
=if(or(reference="",element=""),"",reference&element)

"addie" wrote:

>
> Hi,
>
> I need an "IF" function for the concaterate formula that I'm working on
> below:
>
> Reference Element Consolidation
> 222 10000 22210000 CORRECT
> 10000 10000 WRONG
>
> The consolidation field can only be populated with characters if both
> the reference and element fields are populated. If either 'Reference'
> or 'Element' is missing characters, the consolidation field must be not
> be populated with any characters. It must simply read 'false' or
> 'blank'.
>
> Thanks.
>
>
> --
> addie
> ------------------------------------------------------------------------
> addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
> View this thread: http://www.excelforum.com/showthread...hreadid=390068
>
>