| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage is wrong
I'm trying to get a percentage increase on a dollar amount but the totals are
not correct. $30 is target. +$U$2-D5 is Formula (10%) $33.33 answer |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage is wrong
$30 is 10% less than $33.33
If you want 10% more than $30, it is $30*(1+10%), in other words $33 It is the same situation as the fact that doubling something adds 100%, but halving something subtracts 50%. -- David Biddulph "Scott" wrote in message ... I'm trying to get a percentage increase on a dollar amount but the totals are not correct. $30 is target. +$U$2-D5 is Formula (10%) $33.33 answer |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage is wrong
Thank you very much I thought to much about the formula rather than the
math. "David Biddulph" wrote: $30 is 10% less than $33.33 If you want 10% more than $30, it is $30*(1+10%), in other words $33 It is the same situation as the fact that doubling something adds 100%, but halving something subtracts 50%. -- David Biddulph "Scott" wrote in message ... I'm trying to get a percentage increase on a dollar amount but the totals are not correct. $30 is target. +$U$2-D5 is Formula (10%) $33.33 answer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrong sum value after calculate with Percentage | Excel Worksheet Functions | |||
| Percentage displaying wrong | Excel Discussion (Misc queries) | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
Linear Mode
