Show formulas result + text directly

[veggies27]

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?

 

[Jim Cone]

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?

 

[T. Valko]

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")

 

[Gord Dibben]

Format>Cells>Number>Custom

0.00"/unit"


Gord Dibben MS Excel MVP