"Barry Schwarz" <schwarzb@[EMAIL PROTECTED]
> wrote in message
news:4qelv3dit5m2fesq2p6o1j9349efbidnv3@[EMAIL PROTECTED]
> On Sun, 6 Apr 2008 20:37:20 -0400, "Greg Neill"
> <gneillREM@[EMAIL PROTECTED]
> wrote:
>=20
>> "****p" <****phen@[EMAIL PROTECTED]
> wrote in message
>> news:aef28614-0494-4cf3-a5f7-15273557f1db@[EMAIL PROTECTED]
>>> Hi
>>>=20
>>> I have a mathematical puzzle that I cant solve.
>>>=20
>>>=20
>>> In the table below, the inputs are the values in columns "A" and "B
>>> and the desired output is column "C".
>>>=20
>>>=20
>>> A B C
>>>=20
>>>=20
>>> -3 -3 0
>>> -3 +3 -6
>>> +3 -3 0
>>> +3 +3 +6
>>> 0 0 0
>>>=20
>>>=20
>>> What on earth is the formula in Microsoft Excel that creates "C"?
>>>=20
>>>=20
>>> With thanks
>>>=20
>>>=20
>>> ****p
>>> ****perton Henethe
>>>=20
>>>=20
>>> Clue:
>>> If you strip the sign off "A" and then add "A" and "B" together
>>> and then apply the sign afterwards, you get the correct
>>> answer. But how the heck do you do this in m***cel ?
>>> And/or isnt there a better way of doing the mathematics ? (!)
>>=20
>> =3DSIGN(A1)*(ABS(A1)+B1)
>>=20
> Fails if a1 is 0.
SIGN(0) =3D 0 so the result is 0 as specified.
Without further data points to show otherwise,
we cannot distinguish between this "theory" and
otherwise equivalent ones.
|
