Thread: Tricky formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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"?