View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

You don't give any details, but perhaps something like

="The sum of the first 10 values is " & SUM(A1:A10) & "."

or, if you want to format the value in a particular way, perhaps:

="Three days after the due date is " & TEXT(A1 + 3, "dd mmm yyyy.")


In article ,
"Furrukh" wrote:

I am trying to display calculated value in a text string. The value could
change as the variables change.