Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show formulas result + text directly
I'd like to show the result of a formula in a cell and then directly tack on
some standard text. I want to show a cell that divides a cost by a unit to find a unit cost, then (in the same cell as the unit cost), add " /unit" or something similar. Is this possible without using a bunch of extra cells? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show formulas result + text directly
You can just add the text to the end of the formula, but then the cell value becomes text... =A1/3 &" units" -or- You can use the "N" function and the text will appear only in the formula bar, however the cell value remains numeric... =A1/3 &N("the unit of measure is units") -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "veggies27" wrote in message I'd like to show the result of a formula in a cell and then directly tack on some standard text. I want to show a cell that divides a cost by a unit to find a unit cost, then (in the same cell as the unit cost), add " /unit" or something similar. Is this possible without using a bunch of extra cells? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show formulas result + text directly
Try it like this:
=A1/B1&" /unit" Depending on what the values of A1 and B1 are you may want to round the result. for example: A1 = 10 B1 = 3 =A1/B1&" /unit" Will result in: 3.33333333333333 /unit So: =ROUND(A1/B1,2)&" /unit" Will result in: 3.33 /unit You might also want to make sure there are values in A1 and/or B1: =IF(COUNT(A1:B1)<2,"",ROUND(A1/B1,2)&" /unit") -- Biff Microsoft Excel MVP "veggies27" wrote in message ... I'd like to show the result of a formula in a cell and then directly tack on some standard text. I want to show a cell that divides a cost by a unit to find a unit cost, then (in the same cell as the unit cost), add " /unit" or something similar. Is this possible without using a bunch of extra cells? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show formulas result + text directly
FormatCellsNumberCustom
0.00"/unit" Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 17:56:34 -0700, veggies27 wrote: I'd like to show the result of a formula in a cell and then directly tack on some standard text. I want to show a cell that divides a cost by a unit to find a unit cost, then (in the same cell as the unit cost), add " /unit" or something similar. Is this possible without using a bunch of extra cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas - SUMIF but with a text not number result? | Excel Discussion (Misc queries) | |||
Formulas that show up as text | Excel Discussion (Misc queries) | |||
Formulas never show result??? | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
show text after formulas | Excel Discussion (Misc queries) |