If And Or

[jimbob]

Is it possible to use these together? I am trying to count the number
of times a value occurs in a spreadsheet. This is what I'm trying to
do....

IF the value of G3>0.8 AND the value of H3<0.2, then 1, if not 0, OR if
G3<0.2 and H3>0.8, then 1, if not 0.

 

[daddylonglegs]

This is one way....

=((G3>0.8)+(H3>0.8))*((G3<0.2)+(H3<0.2))

 

[Bob Phillips]

=IF(OR(AND(G3>0.8,H3<0.2),AND(G3<0.2,H3>0.8)),1,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Anne Troy]

=IF(OR(AND(G3>0.8,H3<0.2),AND(G3<0.2,H3>0.8)),1,0)
I think.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com