Help With Basic Feed Back Loop

[STAPLER2]

I have 2 formulas F1 & F2. I need Excel to take the result from F1 and plug it in to F2. I then need Excel to take the result from F2 and plug it back into F1. I want to iterate this 100 times and have the results placed in new cells each time.



Kind regards

[shg]

Alternate the formulas down column F.

Post a workbook if you have questions.

[STAPLER2]

I was looking for a way of doing this besides the obvious multiple entry of the same 2 formulas.


Thanks though.