Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding percentages
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding percentages
Oops, sorry I read it horizontally earlier ..
In E1: =A1*(1+B1)*(1+C1)*(1+D1) should have read as: In A5: =A1*(1+A2)*(1+A3)*(1+A4) Now we're vertically aligned <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding percentages 0 | Excel Discussion (Misc queries) | |||
percentages | Charts and Charting in Excel | |||
percentages | Excel Discussion (Misc queries) | |||
Adding Percentages | Excel Discussion (Misc queries) | |||
Adding percentages in a column and automatic formating of contents | Excel Worksheet Functions |