|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Formula for figuring percentages of 2 numbers
Excellent, thank you.
"Rick Rothstein (MVP - VB)" wrote:
Just divide each column's total by the grand total and format the cells to
show Percentages. For example, if your totals are in Row 100 and the Grand
Total is in D100, then
=A100/D100
=B100/D100
=C100/D100
and whatever cells you put these formulas in, Format Cells to Percentage.
Rick
"Ball4v" wrote in message
...
Let me try that again. In column A I have a list of 1's giving me a total,
column b I have a list of ones, and C, to = a grand total. Out of the
grand
total I need the % of column A, B, and C.
"Gord Dibben" wrote:
=449/578 returns 86% using basic arithmetic.
Your second request is a little vague.
You want a total of column A and total of column B and need a percentage?
=SUM(A1:A10)/SUM(B1:B10) entered in C1
Or maybe =A1/B1 in C1 and copied down to C10
Format all formula cells to percentage.
Gord Dibben MS Excel MVP
On Fri, 27 Jun 2008 21:10:00 -0700, Ball4v
wrote:
I am trying to remember how to manually figure the percentage of the
following:
I have a total of 578 out of that 449 is what percent? Then I need to
know
how to calculate it in an excel spread sheet for each column.
|