Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Repeating Formula
I am trying to creat a formula that will look at a value entered in one cell,
(ex. 10%), then look at another value, (ex. $54K), and multiply by the first value. This will equal $5400, then the formula needs to ad the $5400 to the first $54K and equal $59,400. This part I understand how to do. I now need how to get the new total of $59,400 to auto repeat the process.( Ex. 54K * 10% = 5400 + 54000 = 59,400 * 10% = 5940 + 59400 = 65340 * 10% = etc etc.) A compiling equation. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Repeating Formula
try this where j8 has your 54k and the ^2 is for 2. Chg to whatever desired.
65340 =J8*1.1^2 -- Don Guillett SalesAid Software "cbrock" wrote in message ... I am trying to creat a formula that will look at a value entered in one cell, (ex. 10%), then look at another value, (ex. $54K), and multiply by the first value. This will equal $5400, then the formula needs to ad the $5400 to the first $54K and equal $59,400. This part I understand how to do. I now need how to get the new total of $59,400 to auto repeat the process.( Ex. 54K * 10% = 5400 + 54000 = 59,400 * 10% = 5940 + 59400 = 65340 * 10% = etc etc.) A compiling equation. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Repeating Formula
Assuming you have 10% in cell A1 and 54000 in B1, in B2 use:
=B1*(1+$A$1) Then copy from B2 down to as far as you wish. -Simon "cbrock" wrote: I am trying to creat a formula that will look at a value entered in one cell, (ex. 10%), then look at another value, (ex. $54K), and multiply by the first value. This will equal $5400, then the formula needs to ad the $5400 to the first $54K and equal $59,400. This part I understand how to do. I now need how to get the new total of $59,400 to auto repeat the process.( Ex. 54K * 10% = 5400 + 54000 = 59,400 * 10% = 5940 + 59400 = 65340 * 10% = etc etc.) A compiling equation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
How do I set up a repeating formula in Excel? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Repeating formula in Excel | Excel Discussion (Misc queries) |