I currently have a spreadsheet where I input two variables, lets call them A and B, into 2 cells. It goes through a very complex calculation, and provides a figure C in a 3rd cell.
I would like to build a data table with different values for A and B and display the result of C.
I can input one by one and write down the result. But can I do this with what-if analysis.?
The real questions is, can I build data table without re-writing the equation to get the result?
Bookmarks