IF OR statment

[soxn4n04]

Please help me with the following statement, which is supposed to result in a
total of 3:

=IF(AND(C187=3,OR(C181=1)),3"")

 

[Don Guillett]

if you want it to be if either is true use OR, if both true usd AND
=if(or(c187=3,c181=1),3,"")
=if(and(c187=3,c181=1),3,"")

 

[JulieD]

Hi

either
=IF(AND(C187=3,C181=1),3,"")
if you want BOTH criteria to be true for 3 to be returned.

or

=IF(OR(C187=3,C181=1),3,"")
if you want EITHER criteria to be true for 3 to be returned.

Cheers
JulieD