View Single Post
  #1   Report Post  
Robert
 
Posts: n/a
Default How do I combine the 4 IF formulas into 1 formula

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