0 votes
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, 2023 in Others 318 views

## 1 answer to this question.

0 votes

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)`
answered Jan 10, 2023 by
• 63,420 points

0 votes
1 answer

## 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

0 votes
1 answer

## HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

Try keeping this into your web config ...READ MORE

0 votes
0 answers

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

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

0 votes
1 answer

## 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

0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

0 votes
1 answer

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

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

0 votes
0 answers

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

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

0 votes
1 answer

## IF - ELSE IF - ELSE Structure in Excel

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

0 votes
1 answer

## Need a formula that will pull the specific value that matches a unique code from a set of data and produce another table of that specific data

VLOOKUP will work: vlookup =VLOOKUP(G2,\$A\$2:\$D\$11,3,FALS ...READ MORE

0 votes
1 answer

## Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

You are looking for an IsEmpty check in your ...READ MORE