On Sun, 6 Apr 2008 17:08:26 -0700 (PDT), ****p <****phen@[EMAIL PROTECTED]
>
wrote:
>Hi
>
>I have a mathematical puzzle that I cant solve.
>
>
>In the table below, the inputs are the values in columns "A" and "B
>and the desired output is column "C".
>
>
> A B C
>
>
> -3 -3 0
> -3 +3 -6
> +3 -3 0
> +3 +3 +6
> 0 0 0
>
>
>What on earth is the formula in Microsoft Excel that creates "C"?
>
>
>With thanks
>
>
>****p
>****perton Henethe
>
>
>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 ? (!)
Implementing your clue without addressing its validity:
=(ABS(a1) + b1) * IF(a1 < 0, -1, +1)
You could use the SIGN function if you can guarantee that A is never
zero.
This is not mathematics; it is puzzles.
Remove del for email
|
