Thread: percentages
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gareth_Evans (InterCall EMEA) Gareth_Evans (InterCall EMEA) is offline
external usenet poster
 
Posts: 18
Default percentages

Hi Mich,

Where A2 contains your number and B2 contains your percentage value:

=A2*(1-B2) Decreases 25 by 25%
=A2*(1+B2) Increases 25 by 25%
=A2*(1+35%) Increases 25 by 35%

Hope this helps,

Best Regards

Gareth