2 formulas

R

Roy

Good morning,
is it possible to have 2 different formulas in one cell, and if so, how do I
go about keeping seperate, thx advance
 
K

Kevin B

You could convert your formula results to text and concatenate them together.

=TEXT(SUM(A1:A33),"#,##0.00")&" - "&TEXT(AVERAGE(B1:B33),"#,##0.00")

Look up the TEXT formula in Excel help for list of available formatting
masks.
 
N

Niek Otten

Hi Roy,

What are you trying to achieve?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Good morning,
| is it possible to have 2 different formulas in one cell, and if so, how do I
| go about keeping seperate, thx advance
 
M

Marcelo

hi Roy,

you can embeded functions or use if to have two different actions.

eg.

=if(a1=10,formula,other_formula)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Roy" escreveu:
 
B

Bill Ridgeway

You can have two formulae but only when one is dependent on the other. For
instance you can have an IF, THEN, ELSE scenario (Who remembers Basic?).
Formulae writing is a bit of an art. Perhaps you could outline what you are
trying to achieve for someone to be able to help you better.

Regards.

Bill Ridgeway
Computer Solutions
 
Top