Successive Iteration

[Lory]

Hello,

Here's what I need:

In A1, I have the number x that I'm starting with and in B1, I have
entered the formula that uses x to get a new number which I need it to
be in A2 then B2 uses the A2 number to generate a new number that goes
into A3 and so on......and eventually the number in A should equal the
number in B column.

I have entered the number say 5 in A1, then I typed in the forumla B1
and pressed F9 but nothing happens. I have checked the iteration button
and changed to manual calculation in the Tools --> Options -->
Calculations menu.

Please Help.
Thanks in advance.

-Lory

 

[Michael]

Hi Lori
Sounds like a home budget sheet.
When you have typed the formula in B1 hit enter.
In A2 put =B1. You should be able to drag B1 down as far
as you need to make it do each successive row.
Regards
Michael

 

[Mark Graesser]

Lory,
When you say "nothing happens" do you mean the formula in B1 is still visible and does not calculate? Check the number format in B1, it might be set to text. If so, then reset to general and re-enter your formula.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Lory > wrote: -----

Hello,

Here's what I need:

In A1, I have the number x that I'm starting with and in B1, I have
entered the formula that uses x to get a new number which I need it to
be in A2 then B2 uses the A2 number to generate a new number that goes
into A3 and so on......and eventually the number in A should equal the
number in B column.

I have entered the number say 5 in A1, then I typed in the forumla B1
and pressed F9 but nothing happens. I have checked the iteration button
and changed to manual calculation in the Tools --> Options -->
Calculations menu.

Please Help.
Thanks in advance.

-Lory

 

[Lory]

ooooooops.......OK....let me get this straight.....

when using iteration in excel, it just means we type in a formula i
the cell and drag it to a certain number of columns and it repeats th
formula to these cells and this is called iteration?

I thought there was some sort of feature that it will do it by itsel
until it reaches the percentage tolerance I put in for Tools --
Options --> Calculations (ex. 0.00001) meaning I want the A column t
equal to B plus or minus 0.00001......or is there something lik
this?

for example (Italic fonts = input by user, bold font = by Excel)

Column A Column B
0.00001(input) 0.01657(calculated by certain formula)
0.01657 0.01355
0.01355 0.01415
0.01415 0.01404
....
0.01405 0.0140

Thanks
-Lor

 

[Mark Graeser]

Lory
You might want to consider using Tools>Solver for your operation

I have no idea what the iterations in the Tools>Options>Calculation menu if for. I thought it might be related to Solver but it doesn't seem to be

Good Luck
Mark Graesse
(e-mail address removed)

----- Lory > wrote: ----

ooooooops.......OK....let me get this straight....

when using iteration in excel, it just means we type in a formula i
the cell and drag it to a certain number of columns and it repeats th
formula to these cells and this is called iteration

I thought there was some sort of feature that it will do it by itsel
until it reaches the percentage tolerance I put in for Tools --
Options --> Calculations (ex. 0.00001) meaning I want the A column t
equal to B plus or minus 0.00001......or is there something lik
this

for example (Italic fonts = input by user, bold font = by Excel

Column A Column
0.00001(input) 0.01657(calculated by certain formula
0.01657 0.01355
0.01355 0.0141
0.01415 0.0140
....
0.01405 0.0140

Thank
-Lor

 

[Michael]

Hi Lory
Iteration is that the calculation is done a specified
number of times until the difference in the calc is less
than .001.
Did you try the method I described in the original reply?
Regards
Michael