etong equation na e2
ang dapat mong i-modify. Kasi pag nag resulta ito ng Div/0...mag-eerror na ang susunod mo na formula. To prevent this the denominator (B6 must not be = 0)=(C6*B6+D6+E6)/B6
try this equivalent
So if the B6 cell becomes zero, then it would use the value 0 on that cell else it would follow your formula (C6*B6...etc). This would prevent the division by zero clause.IF(b6=0,0,(C6*B6+D6+E6)/B6)
HTH




Reply With Quote