G Guest Nov 24, 2004 #1 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"")
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 Nov 24, 2004 #2 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,"")
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 Nov 24, 2004 #3 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
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
