Thread: If And Or
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimbob
 
Posts: n/a
Default 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