News Realms Remove Ads - Go Premium! Sign In or Register

Bluetracker

Tracks Blizzard employees across various accounts.

Twitgoogle, help me out. Is there a Google Sheets formula function for this: The value that *would be* in cell X if cell Y's value was changed to Z. I know about goal seeking (find what value of cell X would make cell Y = Z), and this is similar, but not the same.

Twitgoogle, help me out. Is there a Google Sheets formula function for this: The value that *would be* in cell X if cell Y's value was changed to Z. I know about goal seeking (find what value of cell X would make cell Y = Z), and this is similar, but not the same.

  • Chadd Nervigg
    Posted 1 year, 3 months ago (Source)
    Twitgoogle, help me out. Is there a Google Sheets formula function for this: The value that *would be* in cell X if cell Y's value was changed to Z. I know about goal seeking (find what value of cell X would make cell Y = Z), and this is similar, but not the same.

    • _42pe
      Posted 1 year, 3 months ago (Source)
      @Celestalon I’d do this I think: Cell A: Contains value of Y Cell B: Contains Value of Z (Z is the value Y would change to) Cell C: Contains the value of X (a function of Y) Cell D: Contains the potential value of X (but calculated based on Z).

      • Chadd Nervigg
        Posted 1 year, 3 months ago (Source)
        @_42pe Ah, I should clarify that X is a the result of numerous complex calculations across several cells (of which Y is one small variable), and I'm trying to avoid duplicating that whole column of calculations.

        • _42pe
          Posted 1 year, 3 months ago (Source)
          @Celestalon Would duplicating the sheet be an option? Or is this across sheets?

          • _42pe
            Posted 1 year, 3 months ago (Source)
            @Celestalon I don’t know if google has anything like macros, but that would work.

            • Chadd Nervigg
              Posted 1 year, 3 months ago (Source)
              @_42pe I can definitely achieve what I'm trying to through duplicating all the calculation cells. Just was looking for some magic function like WHATIF(A1, 1, B1) that just did something like 'change A1 to 1, read value from B1, then revert A1'. Doesn't seem like that exists though.

    • TheToucherHS
      Posted 1 year, 3 months ago (Source)
      @Celestalon So if I’m reading this correctly, cell X is the result with the formula calculation? Copy the formula from cell X to a new cell, then change the formula to reference cell Z instead of cell Y. Then goal seek the new cell.

      • Chadd Nervigg
        Posted 1 year, 3 months ago (Source)
        @TheToucherHS Yeah, it’s just that “copy the formula from X” was much more elaborate than a single cell. Had to copy all the dozens of cells involved in the final calculation (which is what I ended up doing, just was hoping for something simpler).
Tweet