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: > >> The =ABS(B1) + ABS(C1) has to work in all of the four conditions. it >> only worked when B1 was 10% and C1 was -10%. D1 had 20% (a positive >> number) >> regardless of whether there was positive or negative numbers in B1 and C1. >> >> On Mon, Mar 9, 2009 at 3:40 PM, JOE Conner <[email protected]> >> wrote: >> >> > <<SNIP>> > > Four conditions? What four conditions? > > Can you give an example where the =ABS(B1) + ABS(C1) fails to produce what > you expect? > > > Joe Conner, Poulsbo, WA USA > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
