Forum Discussion

jennigetz's avatar
jennigetz
Copper Contributor
Jan 20, 2019

Excel formula help

I want L2 to calculate what # it'll take to make K2 = 4000, K2 is a SUM

    • jennigetz's avatar
      jennigetz
      Copper Contributor

      Damien thank you so much for trying to help! I'm stuck! Maybe this just can't be done. I tried what you suggested, but it came back and said, "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or moving the formulas to different cells." :(

      • Damien_Rosario's avatar
        Damien_Rosario
        Silver Contributor

        Hi jennigetz

         

        Did you put the formula into L2? If you have put it into K2 it will become circular.

         

        Cheers

        Damien

Resources