Multipul Functions

W

Wolfwillows

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
 
J

JE McGimpsey

One way:

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

another:

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

another:

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

yet another:

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

etc.
 
Top