Multipul Functions
 

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: http://www.excelforum.com/member.php...o&userid=20062
View this thread: http://www.excelforum.com/showthread...hreadid=519235

Multipul Functions
 

One way:

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

another:

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

another:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"%",B1),"^",C 1),"&",D1)

yet another:

="The amount for year " & YEAR(A1) & " was " & TEXT(B1,"$0.00")

etc.

In article ,
Wolfwillows
wrote:

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