Hi
When you want N1 returned, when ALL conditions are filled at once, then:
=(D1<0)*(F1<0)*(H1<0)*(SUM(K1:M1))*(A1="MTH")*N 1
When you want 1 returned, when 1st, 2nd or 3rd condition are filled, 0 when
no of first 3 are filled but 4th is, and N1 when only 5th condition is
filled, then:
=IF(SUM(ABS(D1),ABS(F1),ABS(H1))0,1,IF(SUM(K1:M1) =0,0,(A1="MTH")*N1))
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets
"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
|