I had a feeling that this wasn't possible. So I started playing with the
Pivot Table and using the calculated fields there, I can get the numbers I
want, but it won't show the original count and the calculated percentage, the
information is obviously there, I just can't get it to display in the way I
want. Any thoughts????



"Sandy Mann" wrote:

Assuming that you are entering the Cultures Positive's manually, then no,
you cannot have manually entered data and a formula in the same cell.
Manually entering data overwrites the formula.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Lost in Microbiology" wrote
in message ...
I have several columns of data created from a pivot table. I want the
percent
of total for each row, and have been inserting a column next to each
number
to perform my calculation, and it seems like there should be an easier
way.
Is it possble to have excel do the calculation within the cell and display
the percentage.

Example:
A B C
Virus Cultures Positive Percent of All
Cultures
1 Flu A 10 =B1/$B$5
2 Flu B 15 =B2/$B$5
3 RSV 20 =B3/$B$5
4 Adeno 2 =B4/$B$5
5 Total Cultures 500

For formating and ease of presentation I would love to have two columns
that
look like this:

Virus Cultures Positive (percent)
Flu A 10 (2%)
Flu B 15 (3%)
RSV 20 (4%)
Adeno 2 (0.4%)

As it is my worksheet has grown into a 48 column beast that is a little
unwieldy.

Thanks for any help or tricks!