Dyanamic passing of formula parameters
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.
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.
Take at look at INDIRECT in Excel help.
i dont think you are explaining the problem properly because the way i read it you answer should be:
IF (A1 = x, AZ1, if A1 = y, AZ2,"") ,"")
and then in AZ1 and AZ2 you can have other logic formulas doing the calculation. Clearly either i am reading the problem wrong or you have explained it wrong because that answer is wayyyyy to obvious
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1