Help with And OR statement

[soxn4n04]

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,"")

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[K.S.Warrier]

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

 

[soxn4n04]

Hi, Jason,

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

Kathy

 

[Gord Dibben]

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