Thread: 2 formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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