ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make a cell show totals (https://www.excelbanter.com/excel-discussion-misc-queries/38676-how-make-cell-show-totals.html)

Don

How to make a cell show totals
 
What type of fomual can I use to have a cell show a toal dollar amount plus
additional increase? (i.e. if I have a total of $950 in one cell, I have for
additional cells and want to show 10%, 15%, 20%, 25% growth, is there a
fomula that can show this patten?)

Duke Carey

It's best if you put your percentages in separate cells; that way they are
easier to change if so desired

As an example, put the $950 in cell B1, then the 10%-25% in cells A2 through
A5
In cells B2 use the formula

=$B$1*(1+$A2)

Then copy it down to cells B3:B5


"Don" wrote:

What type of fomual can I use to have a cell show a toal dollar amount plus
additional increase? (i.e. if I have a total of $950 in one cell, I have for
additional cells and want to show 10%, 15%, 20%, 25% growth, is there a
fomula that can show this patten?)



All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com