Multiple IF statement not working
 

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?

Multiple IF statement not working
 

Try this
=B2+COUNTIF(D2:F2,"=1")

--
Wag more, bark less


"Anthony" wrote:

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?

.

Multiple IF statement not working
 

On Dec 17, 11:31*am, Brad wrote:
Try this
=B2+COUNTIF(D2:F2,"=1")

--
Wag more, bark less



"Anthony" wrote:
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?

.- Hide quoted text -

- Show quoted text -

Brad,
For some reason this did not work. It gave me the following: #VALUE!

Multiple IF statement not working
 

On Dec 17, 11:31*am, Brad wrote:
Try this
=B2+COUNTIF(D2:F2,"=1")

--
Wag more, bark less



"Anthony" wrote:
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?

.- Hide quoted text -

- Show quoted text -

I figured it our. Sorry and thanks for your help.

Multiple IF statement not working
 

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")
--
Wag more, bark less


"Anthony" wrote:

On Dec 17, 11:31 am, Brad wrote:
Try this
=B2+COUNTIF(D2:F2,"=1")

--
Wag more, bark less



"Anthony" wrote:
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?

.- Hide quoted text -

- Show quoted text -

Brad,
For some reason this did not work. It gave me the following: #VALUE!
.

Multiple IF statement not working
 

If you can, click the "Yes" button asking if the post answered the question...
--
Wag more, bark less


"Anthony" wrote:

On Dec 17, 11:31 am, Brad wrote:
Try this
=B2+COUNTIF(D2:F2,"=1")

--
Wag more, bark less



"Anthony" wrote:
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?

.- Hide quoted text -

- Show quoted text -

I figured it our. Sorry and thanks for your help.
.