I believe Is it possible to add/subtract in one cell, and have it subtract/add in another cell that already has a value? is the closest I've seen so far, but it still doesn't answer my question.
I have an inventory list in Excel that looks something like this:
The formula I have is supposed to take the value I enter in D3 and subtract it from B3. However, when I do this, I get this circular reference error:
Is there any way to make this calculation so when I credit one cell it debits from another? For instance, if I enter "1" in D3, how do I get it to subtract that from "2" in B3?