I am trying to create a nested If statement involving 9 if values. Instead of creating one gigantic formula involving all of the if, thens I would like to have and if statement that redirects to another cell containing the related formula (like a function section for C++). I would like to be able to pass variables to this formula cell that would change depending on the cell location of the original if formula. In other words I would like to pass some global variables to a related cell which contains a formula using those variables.
example:
IF (A1 = x, go to cell AZ1, if A1 = y, go to cell AZ2, etc.)
AZ1 and AZ2 would compute a formula using values related to A1. But these values would change when A2 is used in the if statement.
Bookmarks