I've been trying to find a way to put text AND a forumla in one cell..
ie: The value of soamp;so [=SUM(c6 e8)] or the like... is this possible at all?
I've never found anything that seems to be able to manage this. obviously the
format would have to be text, but there would be a way, I imagine, to insert
a number as text into a text format.
If I am understanding you correctly then you want to do something
similar
to the following:
you have a number in A1 and B1 and you want to sum those to numbers
and
in the process put quot;The answer isquot; in front of the result.
A1: 2
B1: 2
C1: The answer is 4
In C1 you would put =quot;The answer is quot;amp;A1 B1
In more generic terms it would look like:
=quot;[Your text]quot;amp;[Your formula]
Does this help?--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=507416=quot;the value of so and so is: quot; amp; sum(c6,e8)
or
=quot;the value of so and so is: quot; amp; text(sum(c6,e8),quot;0.00quot;)
or
=quot;the date that it's due is: quot; amp; text(a1,quot;mm/dd/yyyyquot;)
JonARosen wrote:
gt;
gt; I've been trying to find a way to put text AND a forumla in one cell..
gt;
gt; ie: The value of soamp;so [=SUM(c6 e8)] or the like... is this possible at all?
gt; I've never found anything that seems to be able to manage this. obviously the
gt; format would have to be text, but there would be a way, I imagine, to insert
gt; a number as text into a text format.
--
Dave Peterson
- Oct 05 Fri 2007 20:40
impossible way to do something?
close
全站熱搜
留言列表
發表留言