I would be inclined to just use a custom format as opposed to changing the
value to text. If you use the
& "% Completed"
method you can not use the number for calculations...

Format | Cells | Custom - 0.00% "Completed"

This leaves your calculated number in tact and only changes the display of
the number.
--
HTH...

Jim Thomlinson


"Rodman" wrote:

Hello,

I am attempting to show the percentage complete (in a cell) using the
COUNTIF function.

I first formatted a cell (example A1) as a percent the I enter the following
formula in cell A1: =countif(b1:b12,"Completed")/countif(b1:b12,"*")

It returns the correct value in cell A1, however, I would like to add the
word "Completed" after the percent value.

Can Anyone Assist Me?

Thanks In Advance.
--
Rodman Veney