LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding percentages 0 Caractus Excel Discussion (Misc queries) 5 November 15th 06 01:54 PM
percentages Mark Scott Charts and Charting in Excel 1 February 8th 06 09:13 AM
percentages johnsmith Excel Discussion (Misc queries) 4 August 16th 05 07:17 PM
Adding Percentages Homer J Excel Discussion (Misc queries) 0 August 11th 05 09:27 AM
Adding percentages in a column and automatic formating of contents FTP Excel Worksheet Functions 3 May 17th 05 06:14 PM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"