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

 

[oldbrewer]

yes becuse the NEW 80 drives the adjustment to the 100 and 200

100	200	120	80
92.5	192.5	120	95
100	200	120	80
107.5	207.5	120	65
	formula in A2
	=A1+(D1-D2)/2
	so half of D1 minus D2 is added to A1 and B1

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