View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Can you create a dual formula?

Do you mean combine as 2 different results with text in-between?

=D30-D29&" and "&C28*1.5

You might need the text function as well if you need formats like dates or
currency etc

--
Regards,

Peo Sjoblom


"Cryla" wrote in message
...
Is it possible to create a cell with 2 different formulas? I need to
subtract
one cell from another as well as to multiply a cell by a number. Example:
=SUM(D30-D29) and C28*1.5 and have the results combine in the one cell.
Please advise.