Tricky formula

I wondered if it was possible to display the results of two formulae in the
same cell by using concatenation...

Values in A1, A2, A3 are 1, 2, 3, respectively.

In another cell I have this formula: =A1/A2&" / "&A1/A3. The result is
"0.5 / 0.33333333333". Is there a way to format this display so it looks
like "0.50 / 0.33"?

Try =A1/A2&" / "&TEXT(A1/A3,"0.00")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steve" <[email protected]> wrote in message
news:[email protected]...
>I wondered if it was possible to display the results of two formulae in the
> same cell by using concatenation...
>
> Values in A1, A2, A3 are 1, 2, 3, respectively.
>
> In another cell I have this formula: =A1/A2&" / "&A1/A3. The result is
> "0.5 / 0.33333333333". Is there a way to format this display so it looks
> like "0.50 / 0.33"?

Use the TEXT function to format your numbers as desired. E.g.,

=TEXT(A1/A2,"0.00")&" / "&TEXT(A1/A3,"0.00")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Steve" <[email protected]> wrote in message
news:[email protected]...
>I wondered if it was possible to display the results of two
>formulae in the
> same cell by using concatenation...
>
> Values in A1, A2, A3 are 1, 2, 3, respectively.
>
> In another cell I have this formula: =A1/A2&" / "&A1/A3. The
> result is
> "0.5 / 0.33333333333". Is there a way to format this display
> so it looks
> like "0.50 / 0.33"?

=TEXT(A1/A2,"0.00")&" / "&TEXT(A1/A3,"0.00")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve" <[email protected]> wrote in message
news:[email protected]...
> I wondered if it was possible to display the results of two formulae in
the
> same cell by using concatenation...
>
> Values in A1, A2, A3 are 1, 2, 3, respectively.
>
> In another cell I have this formula: =A1/A2&" / "&A1/A3. The result is
> "0.5 / 0.33333333333". Is there a way to format this display so it looks
> like "0.50 / 0.33"?