Forum Discussion
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...
Hi,
Not sure I understand your issue. If you use, for example, the formula
=E41*2
it returns 512 in your case
The formula I'm trying to use the result from is another multi-step calculation. There's a number in J2, so the formula in K2 (which is my problem) is [=((E41*100)-1)+J2] which gives me a circular reference error.
What other data do I need to provide (which cell's formulas are causing my issue)? I've attached a picture of the reference map.
Sorry, but from the picture it's not clear how circular reference appears. Is it possible to receive copy of your file with non-sensitive information to check the formulas?
Thanks for offering to look at this. I've attached a test book. K2 should be 198600.
