close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()