The 7. condition is corrected below. Disregard the 7. condition previously sent.
2009/6/8 Walter Hildebrandt <[email protected]> > The formula IF(OR(A1="";B1="");IF(OR(A1<0;B1<0);"Neg, > Emt";"Empty");IF(OR(B1<0;A1<0);"Negative";IF(B1>0;(A1-B1)/B1;IF(A1=0;1;"∞%")))) > works well for the following 5 conditions below. Please add conditions 6 > and 7 to the formula. I hope to compare the original formula to the new > formula and thereby learn something about the structure of formulas when IF > and OR are in one formula. > > 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 "Negative" appears in > C1. > 4. > > If either A1 or B1 is empty, the word "Empty" appears in C1. > 5. > > However, if both the conditions in 3) and 4), above, are in effect, the > word "Neg, Emt" appears in C1. (if A1 had a negative number and B1 is > empty, > the word "Neg, Emt" would appear in C1 or if A1 is empty and Bi had a > negative number, the word "Neg, Emt" would appear in C1 ) > 6. > > If 0 (zero) appeared in both A1 and B1, the word “00” appears in C1. > 7. > > If 0 (zero) appeared in either A1 or B1, and the 2nd A1 or B1 had > either a positive number, or a negative number, the word “0" appears in C1 > (Stated a different way: If 0 (zero) is in either A1 or B1 while either a > positive or a negative number is in the other A1 or B1 cell) > >
