Incorporating text into cell w/ formula?
 

I have this formula

=SUM(E22*0.5)+1

and want to incorporate it into a single cell along with text so it
will display like this:

Allow 2 hours for bid

The two, of course, being the sum of the formula.

How would I format this?

Thanks in advance! :)


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=570544

Incorporating text into cell w/ formula?
 

="Allow " & SUM(E22*0.5)+1 & " hours for bid"

Incorporating text into cell w/ formula?
 

="Allow " & E22*0.5 +1 & " hours for bid"

Note: the SUM function is not necessary.


Gord Dibben MS Excel MVP


On Thu, 10 Aug 2006 17:43:47 -0400, djarcadian
wrote:


I have this formula

=SUM(E22*0.5)+1

and want to incorporate it into a single cell along with text so it
will display like this:

Allow 2 hours for bid

The two, of course, being the sum of the formula.

How would I format this?

Thanks in advance! :)

Incorporating text into cell w/ formula?
 

Thanks guy! :)


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=570544