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