Multiple IF statement not working

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

I have numbers in cells b2, d2,e2, and f2. I am trying to write
statment that will increment number in cell b2 by one for each cell
(d2, e2, f2) that is greater than or equal to one. The following
formula will not work if more than one cell (d2, e2, f2) has a zero in
it:

=IF(AND(D2>=1,E2>=1,F2>=1),B2+3,IF(OR(D2=0,E2=0,F2=0),B2+2,IF(AND
(D2=0,E2=0),B2+1,IF(AND(D2=0,F2=0),B2+1,IF(AND(E2=0,F2=0),B2+1,)))))

Does anyone know why?
 
B2 must not have a value in it to get this message

What is in B2, D2, E2, F2?

or you can do this
=IF(ISNUMBER(B2),B2,0)+COUNTIF(B2:D2,">=1")
 
Back
Top