| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| Tricky Formula Codes *** Urgent *** | Excel Discussion (Misc queries) | |||
| Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
