IF OR statment

S

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

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

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
 
Top