Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working

Question

I attempted to come up with a formula that would:

Concatenate the contents of the J17 and I17 cells if the value of the J17 cell is not "False" (or any other possible values).

I created the following formula:=IF(J17 & I17, I17)

I ran it after moving it to a different cell, like the K17. The J17 material was supposed to be concatenated to the I17 cell's content (after the original I17 content), however, that is not happening.

What is the issue? What am I overlooking? How can I deal with this problem?

Answer 1

If J17's value is a true or false value, all you should need to do is remove the quotation marks from it in your calculation, making it look like this:

=IF(J17<>False, J17 & I17, I17)