Forum Discussion
Qyn Bayley-Hay
Jun 11, 2018Copper Contributor
Using the answer from one fomula in another formula
Hi All, just like the title says I'm trying to develop a sheet where a series of formulas are updated when a single cell is given a value. essentially it's a numbering system based on some basic math...
Qyn Bayley-Hay
Jun 12, 2018Copper Contributor
I'm confused. J2 in that file is 177001, K2 is =((E41*100)-1)+J2. I changed the COUNT formula in E41 to just be a manually entered number and that fixed things for now. Thank you for your help!
SergeiBaklan
Jun 12, 2018Diamond Contributor
Sorry, I was wrong, that's circular reference due to H2, etc.