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 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] > >
