The formula worked except 2 appeared where emt should appear On Mon, Feb 8, 2010 at 3:54 PM, Gene Kohlenberg <[email protected]>wrote:
> On 2/8/2010 5:26 PM, Walter Hildebrandt wrote: > >> 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) >> >> Put =IF(AND(A4>0;B4>0;D4>0;E4>0)>0;3;IF(OR(A4<0;B4<0;D4<0;E4<0);2;"emp")) > in Z1 > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
