On 2/8/2010 6:28 PM, Walter Hildebrandt wrote:
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]
Ah yes, I didn't test thoroughly. However if I put
=IF(AND(A4>0;B4>0;D4>0;E4>0);3;IF(OR(A4="";B4="";D4="";E4="");"emt";2))
in Z then I get the following results:
A B D E Z
-1 3 2 2 2
-1 2 6 emt
1 1 1 1 3
5 3 6 -1 2
8 4 3 emt
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
