View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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