I am surprised how simple it is Thank you. On Mon, Mar 9, 2009 at 6:45 PM, JOE Conner <[email protected]> wrote:
> 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] >
