+ Reply to Thread
Results 1 to 3 of 3

Dyanamic passing of formula parameters

  1. #1
    Registered User
    Join Date
    08-03-2007
    Posts
    7

    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.

    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.

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286
    Take at look at INDIRECT in Excel help.

  3. #3
    Registered User
    Join Date
    12-08-2008
    Location
    NYC
    MS-Off Ver
    2003 & XP
    Posts
    43
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1