'IF' function

  • Thread starter Thread starter Tat
  • Start date Start date
T

Tat

How do you write a formula to result in an answer that
combines text and the cell reference?

A
1 this
2 that
In this example I would like to come up with a result in
another cell that = the word "What's" and content of the
cell reference (What's this).

I tried the following but it does not work.
=If(A1="","","What's A1")
 
Tat,

=If(A1="","","What's " & A1) Be sure to leave a space after the s and the
closing quote.

Regards,
Kevin
 
Excel uses the & symbol to connect text

="What's "&A1 would produce "What's this

You can also use the CONCATENATE function

Good Luck
Mark Graesse
(e-mail address removed)

----- Tat wrote: ----

How do you write a formula to result in an answer that
combines text and the cell reference


1 thi
2 tha
In this example I would like to come up with a result in
another cell that = the word "What's" and content of the
cell reference (What's this)

I tried the following but it does not work
=If(A1="","","What's A1"
 
-----Original Message-----
How do you write a formula to result in an answer that
combines text and the cell reference?

A
1 this
2 that
In this example I would like to come up with a result in
another cell that = the word "What's" and content of the
cell reference (What's this).

I tried the following but it does not work.
=If(A1="","","What's A1")
.
Click to expand...


Try =If(A1="","", "What's " &A1)


Flynn
 
Back
Top