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]
