| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentages
if i have figures in range A1 to A20 and B1 to B20 how do i easily calculate
them as percentages in C1 to C20 ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentages
=A1/B1 and fill down.
Or =B1/A1 and fill down. Depends what is a percentage of what? -- Brevity is the soul of wit. "mike cooke" wrote: if i have figures in range A1 to A20 and B1 to B20 how do i easily calculate them as percentages in C1 to C20 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Frogs in the pond - Display percentages not numbers | Charts and Charting in Excel | |||
| stacked bar chart with percentages | Charts and Charting in Excel | |||
| Rounding percentages problem need a solution for | Excel Discussion (Misc queries) | |||
| What format do I use to mail merge percentages? | Excel Discussion (Misc queries) | |||
| Calculating Percentages with Variables | Excel Worksheet Functions | |||
Linear Mode
