Hello,
I am using Excel Pro 2003 version. I have an iteration sheet. I have 2 (two) 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 written in result cells. For instance for angle=40, solved area=500, for angle=41, 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.
I am using Excel Pro 2003 version. I have an iteration sheet. I have 2 (two) 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 written in result cells. For instance for angle=40, solved area=500, for angle=41, 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.
