An Equation

[emvella]

Hi,

I think this is impossible but I will take a chance because if it is possible it will save us lot of work and time.

At work I have a CAD software and I use equations to set X, Y, Z positions and material width, length and height. Equations are similar to Excel formulas. So if it works in Excel it will work in the CAD software.

I want a special equation that it ends always with same answer even if I change a particular number from the 4 or more numbers that I have in that equation. (when I say numbers they are positions and sizes of materials).

Example I have:

100+200+120+80=500

And I change 80 to 120, I still want the answer = 500 (means that a particular part stay same position and don't move even if I changed a size of another part).

Thanks

 

[shg]

	a​	b​	c​	d​	e​	f​	g​
2​	100​	200​	120​	80​	500​		e2: =sum(a2:d2)
3​				140​	-20​		e3: {=($e2 - sum(if(isnumber(a3:d3), a3:d3, a2:d2))) / countblank(a3:d3)}
4​	80​	180​	100​	140​	500​		a4: =if(isnumber(a3), a3, a2 + $e3)
5​		60​			40​
6​	120​	60​	140​	180​	500​
7​	100​		100​		30​
8​	100​	90​	100​	210​	500​
9​	100​	100​	100​		-10​
10​	100​	100​	100​	200​	500​

 

[oldbrewer]

100	200	120	80		500
120	220	120	40		500
	formula in A2
	=A1+((D1-D2)/2)
	same principle in B2

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[emvella]

in which cells I write 100 200 120 80 and 120 220 120 40?

 

[shg]

In my example, A2:D2 as shown.

 

[emvella]

100 in (A2) 200 (B2) 120 (C2) 80 (D2)

And you said formula in A2
=A1+((D1-D2)/2)

But in A2 there is the 100

<tbody>
</tbody>

 

[shg]

I don't know who you're talking to. I'll bow out.

 

[emvella]

Yeah, and I'll bow out as well!

 

[emvella]

Hi SHG,

Thanks very much for your help and I like that you posted it within in Excel visible, so I don't get confused with cells.

 

[oldbrewer]

in my solution, 100 is in A1 and the given formula is in A2

 

[emvella]

In my example, A2:D2 as shown.

Hi Oldbrewer I thought that this was your answer and I was confused about A1.

Now we are getting to it
Let's ignore the 500 (because in this formula 500 seems it is not active) and we think about the 140. Is it possible that I change the 80 to whatever I want and I still have the answer 140?

But if possible, as I said in the first thread I prefer the 500 but I think even with 140 I can work it out.