View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default formula to subtract percentage from whole

"Shevvie" wrote:
I want to be able to create a forumla to increase
or decrease the percentage of a whole number i.e.
Nett: 81.47 increase by 15% to give me the total
and vice versa 92.27 decrease by 15% (I can do
this on the calculator). Formula NOT reliant on other
cells.


=81.47*(1+15%)

=92.27*(1-15%)