Forum Discussion
Sum and subtraction
Hi,
First, I'm sorry for my english (I used the google translator to help me)
i have three cells. a1 a2 and a3.
a3 is sum of a1+a2
a3= a1 +a2, example 8 = 2+6,
but I want also be possible when i put:
a1 = a2-a3 or
a2 = a1-a3
regardless where I put the values it calculates the third value
Thanks
18 Replies
Can you explain what it is you trying to accomplish through this calculation?
At the moment, you are experiencing a circular reference in excel since all the cells are referencing one another and no clear "source"/number is manually inputted for a calculation.
adversi and the rest people....
So, let me try explain again...
This is my Spreadsheet
columns:
N. Dev - is to identify the document (In this document (invoices and others) I have products with 6% tax, 23% tax and the total sum of the two tax.
I have to separate the products by tax)6% - is tax produt (it's not important to what I want right now)
23% - is tax produt (it's not important to what I want right now)
Total = 6% + 23%
---------------//--------------
I have to enter the values of 6% and 23%, then the sum appears in column "F"
Image i put : C17+E17 =F17; 5+6=11€;
but sometimes it would be easier for me if I put the value 6% and the total and "excel" calculate the value 23%,; example F17 - C17 = E17; 11€ - 5€= 6€
or put the value of 23% and the total and calculate the value of 6% : example F17 - E17 = C17; 11€ - 6€ = 5€regardless where i places the values, he can calculate the the third value.
Thanks!
Thank you for clarifying. There are multiple ways to "automate" this issue to speed up your process. Are the documents you're using to count the number of products in a spreadsheet or are you manually counting?
If this is already in a spreadsheet, then a function can be used rather than a complex nested formula to allow for dynamic cell inputs.
I am afraid that this doesn't make sense.
In the first place, a1 = a2-a3 and a2 = a1-a3 are not equivalent to a3 = a1+a2.
In the second place, what do you want to happen when you change one cell? Which cell should be kept the same, and which one should be changed?
For example, if I change cell A1, should I change the sum in A3, or should I keep the sum the same and change cell A2 so that A3 still equals A1+A2?
And if I change cell A3, should I keep A1 the same and change A2, or should I keep A2 the same and change A1?
That would result in circular reference, as explained here:
While formulas would lead to circular references, it could be done using VBA - if it were clear what the OP actually wants.
