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"?

Tricky formula
 

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

"Steve" wrote in message
...
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"?

Tricky formula
 

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" wrote in message
...
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"?

Tricky formula
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve" wrote in message
...
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"?