| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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?) |
|
#2
|
|||
|
|||
|
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?) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions | |||
Linear Mode
