Successive Iteration

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


---
Message posted from http://www.ExcelForum.com/

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
>-----Original Message-----
>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
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>

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
mark_graesser@yahoo.com

----- 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


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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
mark_graesser@yahoo.co

----- 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


--
Message posted from http://www.ExcelForum.com

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
>-----Original Message-----
>ooooooops.......OK....let me get this straight.....
>
>when using iteration in excel, it just means we type in a
formula in
>the cell and drag it to a certain number of columns and
it repeats the
>formula to these cells and this is called iteration?
>
>I thought there was some sort of feature that it will do
it by itself
>until it reaches the percentage tolerance I put in for
Tools -->
>Options --> Calculations (ex. 0.00001) meaning I want the
A column to
>equal to B plus or minus 0.00001......or is there
something like
>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.01405
>
>Thanks
>-Lory
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>