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?
Jan 10 in Others 45 views

## 1 answer to this question.

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)`
• 53,160 points

## Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

## What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

## MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE