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"?
>
= if(B <= 0, 0, if(A < 0, -6, 6))
--Lynn
|
