View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Mathematical puzzle (for all you Excel experts)

On Mon, 7 Apr 2008 14:09:11 +0100, "GerryGerry" wrote:

C = B + ABS(A)

"ship" wrote in message
...
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





Fails on example 2
--ron