| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| display contents of cell | Excel Discussion (Misc queries) | |||
| How do I display contents of an adjoining cell? | Excel Worksheet Functions | |||
| Display ALL text contents in cell | Excel Discussion (Misc queries) | |||
Linear Mode
