Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting conditions together.
Hi all,
Another question on excel, how do i nest conditions together for AND, OR and NOT. So far, what i have is =IF (OR('A'!A1=X,'A'!A1=Y),'A'!B1,"") which means that if the field A1 has either X or Y, 'A'B1 will be triggered. else, it'll stay blank. My problem comes with if A1 has either X or (Y and on top of Y, field C1 is NOT blank) then 'A'B1 will be triggered. else, it stays blank. Anyone with any idea on how to make that work? Thanks Ivan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting conditions together.
Hi Maybe =IF (OR('A'!A1=X,AND('A'!A1=Y,'a'!c1<"")),'A'!B1,"") HTH Ivan Koh;340629 Wrote: Hi all, Another question on excel, how do i nest conditions together for AND, OR and NOT. So far, what i have is =IF (OR('A'!A1=X,'A'!A1=Y),'A'!B1,"") which means that if the field A1 has either X or Y, 'A'B1 will be triggered. else, it'll stay blank. My problem comes with if A1 has either X or (Y and on top of Y, field C1 is NOT blank) then 'A'B1 will be triggered. else, it stays blank. Anyone with any idea on how to make that work? Thanks Ivan -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95245 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting conditions together.
Try this.
=IF(OR('A'!A1=X,AND('A'!A1=Y,'A'!C1<"")),'A'!B1," ") If "x" and "y" are values... =IF(OR(A1="X",AND(A1="Y",C1<"")),B1,"") If this post helps click Yes --------------- Jacob Skaria "Ivan Koh" wrote: Hi all, Another question on excel, how do i nest conditions together for AND, OR and NOT. So far, what i have is =IF (OR('A'!A1=X,'A'!A1=Y),'A'!B1,"") which means that if the field A1 has either X or Y, 'A'B1 will be triggered. else, it'll stay blank. My problem comes with if A1 has either X or (Y and on top of Y, field C1 is NOT blank) then 'A'B1 will be triggered. else, it stays blank. Anyone with any idea on how to make that work? Thanks Ivan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting conditions together.
"Ivan Koh" wrote:
My problem comes with if A1 has either X or (Y and on top of Y, field C1 is NOT blank) then 'A'B1 will be triggered. else, it stays blank. =if(AND(C1<"",OR(A1=x,A1=y)), B1, "") You can add the off-sheet syntax and replace "x" and "y" with appropriate values. A more obscure formulation: =if((C1<"")*((A1=x)+(A1=y)),B1,"") Why would you ever do that? To reduce the number of nested functions, which is limited to 7 (8 including the outermost function) in Excel 2003. ----- original message ----- "Ivan Koh" wrote in message ... Hi all, Another question on excel, how do i nest conditions together for AND, OR and NOT. So far, what i have is =IF (OR('A'!A1=X,'A'!A1=Y),'A'!B1,"") which means that if the field A1 has either X or Y, 'A'B1 will be triggered. else, it'll stay blank. My problem comes with if A1 has either X or (Y and on top of Y, field C1 is NOT blank) then 'A'B1 will be triggered. else, it stays blank. Anyone with any idea on how to make that work? Thanks Ivan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting conditions together.
Errata....
I see from other responses that I probably have misunderstood your logical intent. I agree with: =if(or(A1=x,and(A1=y,C1<""),B1,"") or =if((A1=x)+(A1=y)*(C1<""),B1,"") ----- original message ----- "JoeU2004" wrote in message ... "Ivan Koh" wrote: My problem comes with if A1 has either X or (Y and on top of Y, field C1 is NOT blank) then 'A'B1 will be triggered. else, it stays blank. =if(AND(C1<"",OR(A1=x,A1=y)), B1, "") You can add the off-sheet syntax and replace "x" and "y" with appropriate values. A more obscure formulation: =if((C1<"")*((A1=x)+(A1=y)),B1,"") Why would you ever do that? To reduce the number of nested functions, which is limited to 7 (8 including the outermost function) in Excel 2003. ----- original message ----- "Ivan Koh" wrote in message ... Hi all, Another question on excel, how do i nest conditions together for AND, OR and NOT. So far, what i have is =IF (OR('A'!A1=X,'A'!A1=Y),'A'!B1,"") which means that if the field A1 has either X or Y, 'A'B1 will be triggered. else, it'll stay blank. My problem comes with if A1 has either X or (Y and on top of Y, field C1 is NOT blank) then 'A'B1 will be triggered. else, it stays blank. Anyone with any idea on how to make that work? Thanks Ivan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Nesting more than 7 conditions? | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Nesting If Statement with "AND", "OR" conditions | Excel Worksheet Functions |