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