2 formulas one cell possible?

  • Thread starter Thread starter kilogirl78
  • Start date Start date
K

kilogirl78

Is this possible to do in excel? I want two formulas in one cell wher
the answers to the first one displays in the left of the cell and th
answer to the second displays in the right of the cell with a lin
going down the middle seperating the answers. Is that possible to d
in excel?

Thanks for any help
 
Hi
As far as i know, it is not possible, but you can put the formula in
two cells and the answers can be joined with '&' and show in a
different cell.

eg: one formula in A1, other formula in B1 and type the formula in C1
as "=A1&B1". if you need need a line in between you can do this way.
"=A1&" | "&B1"

regards
gt
 
kilogirl78 > said:
Is this possible to do in excel? I want two formulas in one cell where
the answers to the first one displays in the left of the cell and the
answer to the second displays in the right of the cell with a line
going down the middle seperating the answers. Is that possible to do
in excel?
Click to expand...

The plain answer is that you cannot do this.
I am always intrigued as to why people want to do things such as this. Excel
can have so many cells that I find it difficult to see why saving one (or
even many) is so important!
Splash out - use another column!
 
Hi

Why not? An example:

=TEXT(TODAY(),"dd.mm.yyyy") & " | " & TEXT(NOW(),"hh:mm:ss")
 
You could do this in one step, that is concatenate the 2 formulas in one
cell without using intermediate cells. So if your formulae are

=A1*7

and

=TODAY()

you could use

=A1*7 & TODAY()

or better

= TEXT(A1,"#,##0.00") & TEXT(TODAY(),"dd mmm yyyy")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
It would appear to be a strange thing to want to do, but assuming this
is really necessary:

Write the following in cell A1

=IF(B1<DATE(2003,6,1),"'"&TEXT(B1,"mm/dd/yy"),B1)

Format column "A" to be a date format.

In column "B", also a date format, enter "1/1/03" in B1
Enter "6/30/03" in B2

Copy A1 to A2

What you're doing is taking advantage of Excel's natural desire to
start TEXT values from the left and numerical values from the right --
so you add a single quote to the start of the response.

It's not pretty, but it works.

Hope that helps!

Mark
 
Back
Top