The confusing part is that the first IF(OR with the """" seems to work by itself.
The second IF(OR with the < works with the IF(AND and both the IF(OR and IF(AND seem to be related to the 0 at the end of the formula. On Mon, Feb 8, 2010 at 4:20 PM, Walter Hildebrandt <[email protected]> wrote: > Thank you, Johnny. The 2nd one worked great. I am trying to understand > the formula so that I can modify it for different conditions. > > What is the reason there is both IF(or and IF(and used in the formula? > > > On Mon, Feb 8, 2010 at 3:51 PM, Johnny Rosenberg > <[email protected]>wrote: > >> 2010/2/8 Johnny Rosenberg <[email protected]>: >> > 2010/2/8 Walter Hildebrandt <[email protected]>: >> >> How would the following be done? >> >> >> >> Cells A1, B1, D1, E1 have numbers in them that may be greater than 0 >> (vero) >> >> or less than 0 >> >> >> >> In cell Z1, if all the four cells have numbers greater than 0, 3 >> appears. >> >> In cell Z1, if any of the four cells have a number less than 0, 2 >> appears >> >> However, in cell Z1, if any of the four cells are empty, emt appears (a >> 2 or >> >> 3 does not appear) >> >> >> > >> > Maybe something like this (not tested - modify it until it works): >> > >> =if(or(a1="";b1="";d1="";e1="");"";if(and(a1>0;b1>0;d1>0;e1>0);3;if(or(a1<0;b1<0;d1<0;e1<0);2;0))) >> >> Sorry, more like this I presume: >> >> =if(or(a1="";b1="";d1="";e1="");"emt";if(and(a1>0;b1>0;d1>0;e1>0);3;if(or(a1<0;b1<0;d1<0;e1<0);2;0))) >> >> >> > >> > >> > Johnny Rosenberg >> > >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >
