I didn't ask such a question! Please email this question to the person who asked this.
----- Original Message ---- From: Walter Hildebrandt <[email protected]> To: [email protected] Sent: Saturday, June 6, 2009 9:59:13 AM Subject: Re: [users] empty cells and negative numbers in Calc Johnny; OK, if A1 is positive and B1=0 it is C1 can have a "oo" with or without a "%" Walter On Fri, Jun 5, 2009 at 5:38 PM, Johnny Rosenberg <[email protected]>wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
