how do i enter a function in a sentence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
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.
 
Back
Top