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 A2 or B2 had either a positive number, or a negative number, the word “0: appears in C1 (0 is in one cell and either a positive or a negative number is in the other cell)
