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]
