function to display contents of a cell
 

I would like to create a an if function that would display the contents of a
cell. I have only been able to get the function to display the text I typed
in the formula but not the value of the cell. Example: Value of cell B5 is
50. I want the the if function in cell D5 to display "The result is 50" and
not "The result is B5." How do I do this?

function to display contents of a cell
 

One way:

="The result is " & B5

In article ,
ronald wrote:

I would like to create a an if function that would display the contents of a
cell. I have only been able to get the function to display the text I typed
in the formula but not the value of the cell. Example: Value of cell B5 is
50. I want the the if function in cell D5 to display "The result is 50" and
not "The result is B5." How do I do this?

function to display contents of a cell
 

I'm not sure what IF has to do with anything but just write the following
formula: =CONCATENATE("The result is ",B5)

Dave
--
Brevity is the soul of wit.


"ronald" wrote:

I would like to create a an if function that would display the contents of a
cell. I have only been able to get the function to display the text I typed
in the formula but not the value of the cell. Example: Value of cell B5 is
50. I want the the if function in cell D5 to display "The result is 50" and
not "The result is B5." How do I do this?