Forum Discussion

Copper Contributor

Jun 11, 2018

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...

Excel Desktop

Formulas & Functions

Qyn Bayley-Hay

Copper Contributor

Jun 12, 2018

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.

SergeiBaklan

Diamond Contributor

Jun 12, 2018

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?

Qyn Bayley-Hay
Copper Contributor
Jun 12, 2018
Thanks for offering to look at this. I've attached a test book. K2 should be 198600.
Test Data.xlsx23 KB
- SergeiBaklan
  Diamond Contributor
  Jun 12, 2018
  Thank you. In your file K2 is <something>+J2 and J2=K2. Other words, K2=<something>+K2. I have no idea what's the logic behind, but in Excel that doesn't work such way. You shall change your logic for K2 or J2 not have the reference within the cell on itself.
  - Qyn Bayley-Hay
    Copper Contributor
    Jun 12, 2018
    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!