Using Formulas inside of text string

[Sam Fowler]

Hi:

Can anyone tell me if I can do this, and if so, How?

In a spreadsheet, I have a text string (usually in a
group of merged cells), that reads something Like: Based
on the results of this calculation, you have XXXXXXXX, in
unusable widgets. (Actually the text string is closer to
a full paragraph, and also may contain more than one
single result area).

I would like to be able to insert a formula where the
XXXXXXXX, resides in the text. This formula will usually
reference the result of a single cell

Any help on this would be appreciated.

Thanks,

Sam

 

[Don Guillett]

="based "&yourformula&"widgets"

 

[JE McGimpsey]

one way:


= "Based on the results of this calculation, you have " & TEXT(<your
formula here>,"#,##0") & ", in unusable widgets."

So if your formula was

=A1*2

then the formula above becomes:

= "Based on the results of this calculation, you have " &
TEXT(A1*2,"#,##0") & ", in unusable widgets."