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))) Johnny Rosenberg --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
