View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default Displaying cell contents as part of a formula

"jazztalker" wrote in message
...
I am setting up an "if" function that will display a few sentences of text
given a certain condition is true. This I was able to do with no
problems,
but I want to do one more thing with this. Inside of the sentences of
text I
want to display, I want to have it set up so that, inside of my text, it
will
display the contents of a certain cell. For example, if the condition is
true, I want it to say something like: "This review is scheduled for
[month]
and we will be discussing............" where [month] represents the month
typed into a different cell. Is it possible to add something like this
inside of sentences of text I am typing?

Thanks!


="This review is scheduled for "&A1&" and we will be discussing............"
etc.
where A1 contains [month]