Walter Hildebrandt wrote:
When 10 is in both A1 and B1 the ABS answer in C1 is 20
When -10 is in both A1 and B1 the ABS answer in C1 is 20
When -10 is in both A1 and B1 the ABA answer in C1 is 20
When when 10 is in A1 and -10 is in B1 the ABS answer is 20
The ABS gives the same answer (a positive 20) in all of the above
conditions. The goal is a feature that gives how much greater or how much
less A1 is compared to B1 (for example there are 2 cases (2 conditions)
where the answer is 0)
On Mon, Mar 9, 2009 at 4:38 PM, JOE Conner <[email protected]> wrote:
Walter Hildebrandt wrote:
Walter,
In that case, you have the standard definition of subtraction: The
difference between one number and another.
The formula should be =A1-B1 or alternatively =B1 - A1 depending on what
sign you want in the answer.
The results are in the table below for the equasion =B1-A1 through =B4 - A4.
10 10 0
10 -10 -20
-10 10 20
-10 -10 0
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
