How to make a cell show totals

G

Guest

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?)
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Paste in Excel, copies cell and formula, but shows same v 3
Increase percentage formula 1
How to make a column of formulas all ROUND 1
Column sum incorrect upon subtracting 6
Transposing Multiple Cell References to Multiple Values (NOT total 7
Deducting minutes off running total 2
Showing results in cell using formulas 1
Create a SUM of cells horizontally 5

Top