Adding text to the result of a formula?
 

I am curious if there is a way to add text to the result of a formula. For
instance, I would like the formulas

O1: =COUNTIF(N3:N10016, "YES")
P1: =COUNTIF(N3:N10016, "NO")

to appear as:

O1: 1027 Sold
P1: 8987 In Stock

without having to type the text in a different cell.

Thanks in advance,
Robbie

Select cell O1
Choose FormatCells
Select the Number tab
Select the Custom category
In the text box, type: General" Sold"
Click OK

Follow the same instructions for cell P1, using General" In Stock" in
the text box.


Robbie in Houston wrote:
I am curious if there is a way to add text to the result of a formula. For
instance, I would like the formulas

O1: =COUNTIF(N3:N10016, "YES")
P1: =COUNTIF(N3:N10016, "NO")

to appear as:

O1: 1027 Sold
P1: 8987 In Stock

without having to type the text in a different cell.

Thanks in advance,
Robbie




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

=COUNTIF(N3:N10016, "YES")&" Sold"
=COUNTIF(N3:N10016, "NO")&" In Stock"

Vaya con Dios,
Chuck, CABGx3


"Robbie in Houston" wrote in message
...
I am curious if there is a way to add text to the result of a formula.
For
instance, I would like the formulas

O1: =COUNTIF(N3:N10016, "YES")
P1: =COUNTIF(N3:N10016, "NO")

to appear as:

O1: 1027 Sold
P1: 8987 In Stock

without having to type the text in a different cell.

Thanks in advance,
Robbie