software

Is it possible to use 2 or more functions in one single cell? IF so, how
do I do it?

Thanks in advance for all the help.

Wolf--
Wolfwillows
------------------------------------------------------------------------
Wolfwillows's Profile: www.excelforum.com/member.php...oamp;userid=20062
View this thread: www.excelforum.com/showthread...hreadid=519235One way:

=SUM(A1:A10) SUM(B1:B10)

another:

=IF(SUM(A1:B1)gt;0, SUM(C1:C10), 20)

another:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,quot;%quot;,B1),quot;^quot;,C 1),quot;amp;quot;,D1)

yet another:

=quot;The amount for year quot; amp; YEAR(A1) amp; quot; was quot; amp; TEXT(B1,quot;$0.00quot;)

etc.

In article gt;,
Wolfwillows gt;
wrote:

gt; Is it possible to use 2 or more functions in one single cell? IF so, how
gt; do I do it?
gt;
gt; Thanks in advance for all the help.
gt;
gt; Wolf