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
|