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
|