Statistically I don't know what this is called, but what I'm looking for is a
function that will hold a certain fixed realtivity to zero among the
remaining set of numbers if one number is changed. For instance:
1,.-0.5, -0.3, -0.2. these combined net to zero.

if I change 1 to 0.5 I need the other numbers to hold the same relative
distance from zero and net to zero (if that's possible?).

Wouldn't the first number be:
-<cell holding 1*.5
the second:
-<cell holding 1*.3
and the third:
-<cell holding 1*.2?

--
Jim
"Adam" wrote in message
...
| Statistically I don't know what this is called, but what I'm looking for
is a
| function that will hold a certain fixed realtivity to zero among the
| remaining set of numbers if one number is changed. For instance:
| 1,.-0.5, -0.3, -0.2. these combined net to zero.
|
| if I change 1 to 0.5 I need the other numbers to hold the same relative
| distance from zero and net to zero (if that's possible?).

wow, I made that a lot more complicated than I needed to. thanks Jim.


"Jim Rech" wrote:

Wouldn't the first number be:
-<cell holding 1*.5
the second:
-<cell holding 1*.3
and the third:
-<cell holding 1*.2?

--
Jim
"Adam" wrote in message
...
| Statistically I don't know what this is called, but what I'm looking for
is a
| function that will hold a certain fixed realtivity to zero among the
| remaining set of numbers if one number is changed. For instance:
| 1,.-0.5, -0.3, -0.2. these combined net to zero.
|
| if I change 1 to 0.5 I need the other numbers to hold the same relative
| distance from zero and net to zero (if that's possible?).

I don't know that there's a function that will do that, however, try
the Solver tool. Tools-- Solver

On Oct 2, 2:45 pm, Adam wrote:
Statistically I don't know what this is called, but what I'm looking for is a
function that will hold a certain fixed realtivity to zero among the
remaining set of numbers if one number is changed. For instance:
1,.-0.5, -0.3, -0.2. these combined net to zero.

if I change 1 to 0.5 I need the other numbers to hold the same relative
distance from zero and net to zero (if that's possible?).