View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Adding percentages

If Max has guessed your intentions correctly you can also use the
following *array* formula for less typing, if you have many
percentages:

=A1*PRODUCT(1+A2:A4)

As this is an array formula commit with Shift+Ctrl+Enter

HTH
Kostis Vezerides

On Jul 6, 12:02 pm, wghenry wrote:
I have a number in a cell eg .834 and I wish to show a % increase in
subsequent cells 13% increase, 12% increase etc. How do I create a formula to
show these percebntage increases and show the total in a cell eg

.834 * 8% * 13% *2% = Total shows 1.037

I want to show the percentages in individual cells eg
A1 A2 A3 A4 A5
.834 8% 13% 2% =1.037 (Cells A2 - A4 formatted as
a %)

Thank you.
--
wghenry