2 formulas
 

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

2 formulas
 

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.
--
Kevin Backmann


"Roy" wrote:

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

2 formulas
 

Hi Roy,

What are you trying to achieve?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Roy" wrote in message ...
| 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

2 formulas
 

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:

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

2 formulas
 

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

"Roy" wrote in message
...
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