percentage

  • Thread starter Thread starter Ralph Smith
  • Start date Start date
R

Ralph Smith

Jan 10
Feb 15
Mar 25

Total 50

What is the best way to figure the percentages of each? Do I create
another column? What is the best formula to use?

Thanks.
 
Hi Ralph
in the adjacent column enter the following
=A1/$A$5 -> if A5 is the cell that stores your total
copy down
format this row as percentage ('Format - Cells')

Frank
 
or. to avoid a total cell

=A1/SUM($A$1:$A$4)

obviously adjust to suit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top