| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to calculate a percentage formula with existing data?
I already have my data entered on the spreadsheet. I need to know a formula
that would give me a percentage of each row or column. Any help would be greatly appreciated! Thanks, Meagan |
|
#2
|
|||
|
|||
|
The formula for a percentage is =part/whole. If your data is in column A
with a SUM in cell A10, you could put this formula in B1 =A1/A$10. Then format the cell as a percentage. This formula could then be filled down column B to do the same calculation for the rest of the rows. Carlos "MeaganNW" wrote in message ... I already have my data entered on the spreadsheet. I need to know a formula that would give me a percentage of each row or column. Any help would be greatly appreciated! Thanks, Meagan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to calculate a percentage formula with existing data?
"MeaganNW" wrote: I already have my data entered on the spreadsheet. I need to know a formula that would give me a percentage of each row or column. Any help would be greatly appreciated! Thanks, Meagan |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to calculate a percentage formula with existing data?
"MeaganNW" wrote: I already have my data entered on the spreadsheet. I need to know a formula that would give me a percentage of each row or column. Any help would be greatly appreciated! Thanks, Meagan |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to calculate a percentage formula with existing data?
Hi sads,
Assuming your data are in A1:A10, you could use a formula like: =A1/SUM(A$1:A$10) in B1 and copy down to B10. Alternatively, if you've got a total in A11, you could use a formula like: =A1/A$11 in B1 and copy down to B10. in either case, format the cells as %. -- Cheers macropod [MVP - Microsoft Word] "sads" wrote in message ... "MeaganNW" wrote: I already have my data entered on the spreadsheet. I need to know a formula that would give me a percentage of each row or column. Any help would be greatly appreciated! Thanks, Meagan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| formula to determine the first column containing any data | Excel Worksheet Functions | |||
| What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
| Importing Data Into Formula Based Cells | Excel Worksheet Functions | |||
Hybrid Mode
