Text sentence with a formula ... is it possible

  • Thread starter Thread starter cmm
  • Start date Start date
C

cmm

I want to have in one cell for example:

The wagon is at a cost of $

after the dollar sign I want to have a formula referenced
from another cell. Is this possible?

Thanks.
 
Assuming the text phrase "The wagon is at a cost of $" is in A1,
and in A2 is a formula, say: =SUM(E1:F1) evaluating to say, a number 3, then

:=A1&A2
gives "The wagon is at a cost of $3"

:=A1&TEXT(A2,"#,##0.00")
gives "The wagon is at a cost of $3.00"
 
Right-click on your cell, Format > Custom > in the window type "The wagon is
at a cost of $###.## > ok
then, put whatever formula you want in the cell and it will read as you
desire......

Vaya con Dios,
Chuck, CABGx3
 
sorry, left out a "
should be
"The wagon is at a cost of $"###.##

Vaya con Dios,
Chuck, CABGx3
 
Back
Top