Help with And OR statement
 

Please help with the following statement. If cells 17 and 23 have a value of
3 OR cell 29 has a value of 3, then the result should be 2.

IF(AND(C17=3,C23=1)(ORC29=3),2,"")

=IF(OR(C29=3,AND(C17=3,C23=1)),2,"")

HTH
Jason
Atlanta, GA

-----Original Message-----
Please help with the following statement. If cells 17
and 23 have a value of
3 OR cell 29 has a value of 3, then the result should be
2.

IF(AND(C17=3,C23=1)(ORC29=3),2,"")
.

Hi,
Try this
=if(or(and(c17=3,c23=3),c29=3),2,"")
K.S.warrier

"Jason Morin" wrote:

=IF(OR(C29=3,AND(C17=3,C23=1)),2,"")

HTH
Jason
Atlanta, GA

-----Original Message-----
Please help with the following statement. If cells 17
and 23 have a value of
3 OR cell 29 has a value of 3, then the result should be
2.

IF(AND(C17=3,C23=1)(ORC29=3),2,"")
.

Hi, Jason,

Thanks for responding. I entered your formula but it did not work. Any
other suggestions?

Kathy

"Jason Morin" wrote:

=IF(OR(C29=3,AND(C17=3,C23=1)),2,"")

HTH
Jason
Atlanta, GA

-----Original Message-----
Please help with the following statement. If cells 17
and 23 have a value of
3 OR cell 29 has a value of 3, then the result should be
2.

IF(AND(C17=3,C23=1)(ORC29=3),2,"")
.

Try =IF(OR(C29=3,AND(C17=3,C23=3)),2,"")


This matches your description, not the parameters of your original formula
which said if C17=3 and C23=1

Gord Dibben Excel MVP

On Mon, 29 Nov 2004 10:44:12 -0800, "soxn4n04"
wrote:

Hi, Jason,

Thanks for responding. I entered your formula but it did not work. Any
other suggestions?

Kathy

"Jason Morin" wrote:

=IF(OR(C29=3,AND(C17=3,C23=1)),2,"")

HTH
Jason
Atlanta, GA

-----Original Message-----
Please help with the following statement. If cells 17
and 23 have a value of
3 OR cell 29 has a value of 3, then the result should be
2.

IF(AND(C17=3,C23=1)(ORC29=3),2,"")
.