You can use boolean results (False is '0', True is '1') to simplify your
equation:
For example, if you use =D1<0 as a formula Excel will evaluate the result
1 if D1 does not contain 0 (ie TRUE) or 1 if D1 contains anything else (ie
FALSE).

Use parenthesis and you can do fast, simple (when you get used to the logic)
evaluations.

In place of the equation you have at N1
=(D1<0)+(F1<0)+(H1<0)0







"Robert" wrote in message
...
K1=IF(D1<0,1,0)
L1=IF(F1<0,1,0)
M1=IF(H1<0,1,0)
N1=IF(SUM(K1:M1)=0,0,1)
O1=IF(A1=MTH,N1,0)

Assistance required. How can the formula in O1 combine
K1,L1,M1,N1. It is a simple formula, but I admit I am not
able to get it right at all even after looking through several
examples posted in this forum. Thank you.
RobertR