Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |