IF/AND FORMULA
 

Seek assistance in the formula for IF C9=10 and A9=2 or"2D" or "3S"
should return B9 else "0000"

I wrote as
=IF(AND(A9=2,C9=10),B9,IF(AND(A9="2D",C9=10),B9,IF (AND(A9="3S",C9=10,B9))). I
get the correct number if the conditions comply,
else a "FALSE". I am unable correct my formula to incorporate "0000"

Thank you.
--
Robert

=if(or(and(c9=10,a9=2),a9="2D",a9="3S"),B9,"0000")
HTH,
--
Gary Brown



"Robert" wrote:

Seek assistance in the formula for IF C9=10 and A9=2 or"2D" or "3S"
should return B9 else "0000"

I wrote as
=IF(AND(A9=2,C9=10),B9,IF(AND(A9="2D",C9=10),B9,IF (AND(A9="3S",C9=10,B9))). I
get the correct number if the conditions comply,
else a "FALSE". I am unable correct my formula to incorporate "0000"

Thank you.
--
Robert

You left out the response if false
In your equation change it to
=IF(AND(A9=2,C9=10),B9,IF(AND(A9="2D",C9=10),B9,IF (AND(A9="3S",C9=10,B9,"OOOO")))

a little simple form would be
=if(and(C9=10,or(A9=2,A9="2D",A9="3S")),B9,"OOOO")

"Robert" wrote:

Seek assistance in the formula for IF C9=10 and A9=2 or"2D" or "3S"
should return B9 else "0000"

I wrote as
=IF(AND(A9=2,C9=10),B9,IF(AND(A9="2D",C9=10),B9,IF (AND(A9="3S",C9=10,B9))). I
get the correct number if the conditions comply,
else a "FALSE". I am unable correct my formula to incorporate "0000"

Thank you.
--
Robert

I *think* this needs to be

=IF(AND(C9=10,OR(A9=2,A9="2D",A9="3S")),B9,"0000)


"Gary Brown" wrote:

=if(or(and(c9=10,a9=2),a9="2D",a9="3S"),B9,"0000")
HTH,
--
Gary Brown



"Robert" wrote:

Seek assistance in the formula for IF C9=10 and A9=2 or"2D" or "3S"
should return B9 else "0000"

I wrote as
=IF(AND(A9=2,C9=10),B9,IF(AND(A9="2D",C9=10),B9,IF (AND(A9="3S",C9=10,B9))). I
get the correct number if the conditions comply,
else a "FALSE". I am unable correct my formula to incorporate "0000"

Thank you.
--
Robert

Thank you Duke, you formula is what I wanted.

Gary and bj, both your identical formula did not test for "C9"
bj, your correction of of my formula missed a "close bracket"
atfter the 3rd "C10".
Thanks to all of you.
--
Robert


"Duke Carey" wrote:

I *think* this needs to be

=IF(AND(C9=10,OR(A9=2,A9="2D",A9="3S")),B9,"0000)


"Gary Brown" wrote:

=if(or(and(c9=10,a9=2),a9="2D",a9="3S"),B9,"0000")
HTH,
--
Gary Brown



"Robert" wrote:

Seek assistance in the formula for IF C9=10 and A9=2 or"2D" or "3S"
should return B9 else "0000"

I wrote as
=IF(AND(A9=2,C9=10),B9,IF(AND(A9="2D",C9=10),B9,IF (AND(A9="3S",C9=10,B9))). I
get the correct number if the conditions comply,
else a "FALSE". I am unable correct my formula to incorporate "0000"

Thank you.
--
Robert