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