Prev: How do I set a pivot table to group quarterly reports by F/Y?
Next: Sorting Question
From: Jim Thomlinson on 3 Mar 2010 15:09
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
First  |  Prev  | 
Pages: 1 2
Prev: How do I set a pivot table to group quarterly reports by F/Y?
Next: Sorting Question