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]
