Johnny; In this situation the word "zeros" will appear in C1 (if that is possible to be added)
Walter On Fri, Jun 5, 2009 at 5:39 PM, Johnny Rosenberg <[email protected]>wrote: > And I forgot, if both A1 and B1 are 0, should then the output be ”100 > %”, since A1 and B1 then are equal? > > Johnny Rosenberg > > > 2009/6/6 Johnny Rosenberg <[email protected]>: > > 2009/6/6 Walter Hildebrandt <[email protected]>: > >> Johnny; > >> > >> If there is a 0 (zero) it is considered to be a positive number. I > missed > >> this concept when I was using the words "positive number". > >> > >> Walter > > > > Ok, and what about if A1 is positive and B1=0? Then A1 is ∞ % greater > > than B1… Is it OK if the formula outputs ”∞” or maybe ”∞ %” in that > > particular case? > > > > > > (In case UTF-8 characters does not make it through all the email > > servers on the way, ∞=the "infinity" character). > > > > > > Johnny Rosenberg > > > > > >> > >> On Fri, Jun 5, 2009 at 5:12 PM, Johnny Rosenberg < > [email protected]>wrote: > >> > >>> What about if A1 or B1 is 0? That's not covered in any of the five > >>> conditions below. > >>> > >>> Kind regards > >>> > >>> Johnny Rosenberg > >>> > >>> 2009/6/6 Walter Hildebrandt <[email protected]>: > >>> > What formula would be used to meet the following conditions? > >>> > > >>> > 1) If both A1 and B1 are positive numbers, and A1 is greater than B1, > get > >>> a > >>> > positive number, in C1. The number in C1 is the percentage by how > much A1 > >>> is > >>> > greater that B1. > >>> > > >>> > 2) If both A1 and B1 are positive, and A1 is less than B1, get a > negative > >>> > number , in C1. The number in C1 is the percentage by how much A1 is > less > >>> > than B1. > >>> > > >>> > 3) If either A1 or B1 is a negative number, the word “Neg” appears in > C1. > >>> > > >>> > 4) If either A1 or B1 is empty, the word “Em” appears in C1. > >>> > > >>> > 5) If both the conditions in 3) and 4), above, are in effect, the > word > >>> “Neg > >>> > Em” appears in C1. *(for example, if A1* had a negative number and B1 > is > >>> > empty, the word “Neg Em” would appear in C1) > >>> > > >>> > >>> --------------------------------------------------------------------- > >>> To unsubscribe, e-mail: [email protected] > >>> For additional commands, e-mail: [email protected] > >>> > >>> > >> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
