Tricky formula

S

Steve

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

Chip Pearson

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top