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]
