'IF' function

[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")

 

[Kevin Stecyk]

Tat,

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

Regards,
Kevin

 

[Don Guillett]

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

 

[Mark Graesser]

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"

 

[Guest]

-----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")
.

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


Flynn