If And Or
 

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 G30.8 AND the value of H3<0.2, then 1, if not 0, OR if
G3<0.2 and H30.8, then 1, if not 0.


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=506094

If And Or
 

This is one way....

=((G30.8)+(H30.8))*((G3<0.2)+(H3<0.2))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=506094

If And Or
 

=IF(OR(AND(G30.8,H3<0.2),AND(G3<0.2,H30.8)),1,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"jimbob" wrote in
message ...

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 G30.8 AND the value of H3<0.2, then 1, if not 0, OR if
G3<0.2 and H30.8, then 1, if not 0.


--
jimbob
------------------------------------------------------------------------
jimbob's Profile:
http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=506094

If And Or
 

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

"jimbob" wrote in
message ...

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 G30.8 AND the value of H3<0.2, then 1, if not 0, OR if
G3<0.2 and H30.8, then 1, if not 0.


--
jimbob
------------------------------------------------------------------------
jimbob's Profile:
http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=506094