View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Adding percentages

One guess, perhaps you mean

In E1:
=A1*(1+B1)*(1+C1)*(1+D1)

With A1 containing a keyed in: 0.834, E1 returns: 1.038
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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