Forum Discussion
Excel formula help
I want L2 to calculate what # it'll take to make K2 = 4000, K2 is a SUM
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." :(
Hi jennigetz
Did you put the formula into L2? If you have put it into K2 it will become circular.
Cheers
Damien
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!
Hi jennigetz
You are doing great and trial and error is part of the learning experience!
The example I gave was with K2 as a SUM and it worked OK (please see file attached).
What formula are you using in K2?
If you are able, it may be worthwhile to upload the file (remove any personal info) and I can have a quick squiz if you would like. Otherwise have a look at the file attached and see if that helps to pinpoint the issue.
Cheers
Damien
