Is there a way to enter a function into a sentence in Excel? As in the
following example, I am trying to type a sentence with a function to
automatically display the results of a cell in the same sentence:

This quote is based on an total lump sum estimate not to exceed "$10,000"

="this quote..." & text(a1,"$#,##0.00") & " and is due " & text(b1,"mm/dd/yyyy")

Joe Reyes wrote:

Is there a way to enter a function into a sentence in Excel? As in the
following example, I am trying to type a sentence with a function to
automatically display the results of a cell in the same sentence:

This quote is based on an total lump sum estimate not to exceed "$10,000"

--

Dave Peterson

I'm not sure if I understand your question correctly but I'm making the
assumption that the $10,000 is the variable, and is what you want to
insert into the sentence from a cell value somewhere else.

If you have your "not to exceed" amount in cell A1.

Enter this formula:
="This quote is based on an total lump sum estimate not to exceed
"&dollar(A1,0)

This will give you a sentance that always reads the same except for the
"not to exceed" dollar amount which will change as you calculate it
differently for each individual.

Hope that helps.


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=509204