| Home |
| Search |
| Today's Posts |
|
|
|
#1
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figuring out a formula | Excel Worksheet Functions | |||
| How do I change numbers and percentages in a formula?? | Excel Worksheet Functions | |||
| Problem figuring formula | Excel Discussion (Misc queries) | |||
| Figuring Out A formula to... | New Users to Excel | |||
| I Need help figuring out a sports formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
