Add text to formula?

[Pete_UK]

Have your tried doing this:

="You:Computer = "&COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
Lost*")

?

Hope this helps.

Pete

 

[StargateFan]

I have this formula kindly given to me in one of these Excel ngs:

=COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You Lost*")

The challenge is that any custom text I add to the cell formatting
doesn't show up in the cell. Would it be possible to add something
like this text below to the above (but also including line breaks)?:

****************************************************************
Score
---------
You:Computer =
Formula result of: =COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
Lost*")
****************************************************************

Thanks! D

 

[Pete_UK]

Yes, you can do this:

="You:Computer = "&CHAR(10)&COUNTIF(E:E,"You Won!*")&":"&COUNTIF
(E:E,"You Lost*")

You need to format the cell to Wrap Text, and you might need to adjust
the row height manually to see both.

Basically, the CHAR(10) is equivalent to <new line>.

Hope this helps.

Pete

 

[StargateFan]

Have your tried doing this:

="You:Computer = "&COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
Lost*")

Close enough for now, thanks much. Much better than what I had up
till now which is a separate cell for the "title" of the score ratio.

Just out of curiousity, is there no way to get in "carriage returns"
in there, is there? <g>

Thanks! D

 

[StargateFan]

Yes, you can do this:

="You:Computer = "&CHAR(10)&COUNTIF(E:E,"You Won!*")&":"&COUNTIF
(E:E,"You Lost*")

You need to format the cell to Wrap Text, and you might need to adjust
the row height manually to see both.

Basically, the CHAR(10) is equivalent to <new line>.

Hope this helps.

Very kewl! Will give this a try later on tonight. Thanks! D

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Very kewl!  Will give this a try later on tonight.  Thanks!  D





- Show quoted text -