software

I'm working on and have been forever a quote sheet. Many of the values
change based on certain criteria. I have a disclaimer sentence at the
bottom of the page and I would to have it set up that when I change the
criteria in the work sheets it would also change it in the sentence. Does
this make sense?

Marc
Use the amp; (concatenate) operator along with the TEXT funtion. For instance:
=quot;Today is quot; amp; text(today()),quot;Mmmm dd, yyyyquot;). Inside the text function, you
can calculate and format any formula (such as today()) you like.
--Bruce

quot;Marcquot; wrote:

gt; I'm working on and have been forever a quote sheet. Many of the values
gt; change based on certain criteria. I have a disclaimer sentence at the
gt; bottom of the page and I would to have it set up that when I change the
gt; criteria in the work sheets it would also change it in the sentence. Does
gt; this make sense?
gt;
gt; Marc
gt;
gt;
gt;

Yes, you could have a formula like this:

=quot;This price of quot;amp;TEXT(B1,quot;0.00quot;)amp;quot; is valid for 10 days only from
quot;amp;TEXT(A1,quot;dd/mm/yyyyquot;)

this picks up a date from A1 and your price from B1 and inserts them
into your disclaimer sentence. You can adapt this to suit your
circumstances.

Hope this helps.

PeteGuys thanks that's exactly what I'm looking for.

Marc

quot;Marcquot; gt; wrote in message ink.net...
gt; I'm working on and have been forever a quote sheet. Many of the values
gt; change based on certain criteria. I have a disclaimer sentence at the
gt; bottom of the page and I would to have it set up that when I change the
gt; criteria in the work sheets it would also change it in the sentence. Does
gt; this make sense?
gt;
gt; Marc
gt;
gt;
Thanks for feeding back.

Pete
bpeltzer Wrote:
gt; Use the amp; (concatenate) operator along with the TEXT funtion. For
gt; instance:
gt; =quot;Today is quot; amp; text(today()),quot;Mmmm dd, yyyyquot;). Inside the text
gt; function,
gt;
gt; gt;[/color]Could be this?

=quot;Today is quot; amp; TEXT(TODAY(),quot;Mmmm dd, yyyyquot;)--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=518900