| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
