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