Hello,

I am using Excel Pro 2003 version. I have an iteration sheet with 2
variables which are Angle and Area.

First I set the angle constant and have the iteration solved the area. Then
I increase the angle and iteration solves the area for the new input angle.
While I am doing the iteration, I want to have the angle and area results to
be saved in result sheet.

For instance for
angle=40, solved area=500, for
angle=41, solved area=550...and so on.

What kind of formula I need to write in the "result" cell so I can have the
angle and area values to be kept there while iteration goes on. I tried to
write with IF statements but when the angle changes area is changing so does
my "result" cell that suppose to keep the results.

I tried to write like this:
A1, where the angle is
A2, where the area is

=IF(A1=40;A2;"")
=IF(A1=41;A2;"")
I want to keep the results so "" part is wrong but I do not know what to
write there so I can keep the results.

Thank you very much.