percentage

[Trish]

In an elcetion poll I have all of Bush's popular votes and
all of Gore's Popular vote and I have figured the
difference between the two now I need to figure the
Percentage differential in the popular vote. This is the
difference in the number of votes (/) the total number of
votes. How do I write a formual for this?

A4 is Popular Votes B4 is Gores total Popular Votes
C4 is Bush's total Popular Votes
G9 is is the Differences in their popular votes.
H9 is where I am suppose to enter the Percentage
differential in popular votes.

Please Help.

 

[one_idea]

Trish;

In order to make the formula you create re-usable, it's
best to calculate the percentages in some intermediary
cells, then reference those in the final 'differential'
cell.

For example: in say, B5 and C5, you can enter a simple
percentage calculation like =B4/A4 and =C4/A4 (format
those two cells as %).

Then in H9 you can enter a simple =B5-C5.

good luck!