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
excel
  • jennigetz's avatar
    jennigetz
    Copper Contributor
    Jan 21, 2019

    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
      Jan 21, 2019

      Hi jennigetz

       

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

       

      Cheers

      Damien

      • jennigetz's avatar
        jennigetz
        Copper Contributor
        Jan 21, 2019

        yes I tried it in L2

        I think the problem is that K2 is already a sum

        It's not the biggest deal in the world, I just have to manually enter #s into L2 until K2 gets close to 4000

        G & I use L so I think that's the problem

        I'm just not that familiar with Excel, I'm proud of myself for even getting this far :) 

        Thank you again for trying to help!

         

Resources