Adding text to the result of a formula?

[Robbie in Houston]

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]

Select cell O1
Choose Format>Cells
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.

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3