| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage formula in excel
I have 4 columns which I have set up with a formula to calculate percentage.
The 4 column formulas should equal 100% but they equal 106%. Can you help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage formula in excel
Yes, if you tell us what formula and data you have.
Regards, Fred "Trevea" wrote in message ... I have 4 columns which I have set up with a formula to calculate percentage. The 4 column formulas should equal 100% but they equal 106%. Can you help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage formula in excel
"Trevea" wrote: I have 4 columns which I have set up with a formula to calculate percentage. The 4 column formulas should equal 100% but they equal 106%. Can you help? Column Totals 971,978.64 4,050.00 734,810.51 247,068.13 %from formulas 1.86% 0.42% 75.92% 25.53% formulas e38/d38 f38/3/38 G38/(e38-f38) h38/(e38-f38) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage formula in excel
"Trevea" wrote: "Trevea" wrote: I have 4 columns which I have set up with a formula to calculate percentage. The 4 column formulas should equal 100% but they equal 106%. Can you help? Column Totals 971,978.64 4,050.00 734,810.51 247,068.13 %from formulas 1.86% 0.42% 75.92% 25.53% formulas e38/d38 f38/3/38 G38/(e38-f38) h38/(e38-f38) The percentage totals are now 103.74% |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage formula in excel
"Trevea" wrote: "Trevea" wrote: "Trevea" wrote: I have 4 columns which I have set up with a formula to calculate percentage. The 4 column formulas should equal 100% but they equal 106%. Can you help? Sorry the last post had incorrect information Column Totals d38 52,301,407,62 e38 971,978.64 f38 4050.00 g38 734,810.51 h38 247,068.13 Formulas e38/d38 f38/e38 g38/(e38-f38) h38/(e38-f38) f38/e38 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage formula in excel
Why do you expect the percentages to add to 100%? You're not dividing by the
sum of the numbers. If you're want to calculate the percentage of the total, first make sure you're dividing by the total. Regards, Fred. "Trevea" wrote in message ... "Trevea" wrote: "Trevea" wrote: "Trevea" wrote: I have 4 columns which I have set up with a formula to calculate percentage. The 4 column formulas should equal 100% but they equal 106%. Can you help? Sorry the last post had incorrect information Column Totals d38 52,301,407,62 e38 971,978.64 f38 4050.00 g38 734,810.51 h38 247,068.13 Formulas e38/d38 f38/e38 g38/(e38-f38) h38/(e38-f38) f38/e38 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage formula in Excel spreadsheet | New Users to Excel | |||
| what formula is used in Excel to find percentage of value? | Setting up and Configuration of Excel | |||
| How do I use a formula in excel to get a percentage discount | Excel Discussion (Misc queries) | |||
| Excel formula that calculates percentage of increase or decrease | Excel Worksheet Functions | |||
| Percentage Formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
