Forum Discussion
jennigetz
Jan 20, 2019Copper Contributor
Excel formula help
I want L2 to calculate what # it'll take to make K2 = 4000, K2 is a SUM
- Damien_RosarioSilver Contributor
- jennigetzCopper 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_RosarioSilver Contributor
Hi jennigetz
Did you put the formula into L2? If you have put it into K2 it will become circular.
Cheers
Damien