Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can not seem to get my IF / AND statement to work, help please
This is my IF / AND statement that I can not get to work.
(=IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3))),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))). Does any one have any suggestions to what I am doing incorrectly? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can not seem to get my IF / AND statement to work, help please
See if this is what you want. Note: Your last IF statement does not appear
to have a FALSE conditions. In other words, what should it do if it is False? =IF(AND(D3="yes",E3="",K3="M"),G3-I3-(H3+I3+J3),IF(AND(D3="yes",E3="",K3="L"),G3-I3-J3,IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3), IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3)))) HTH, Paul -- "petester" wrote in message ... This is my IF / AND statement that I can not get to work. (=IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3))),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))). Does any one have any suggestions to what I am doing incorrectly? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can not seem to get my IF / AND statement to work, help please
You need to check the matching of the parentheses for each IF statement, and
you need to ensure that each IF has 3 arguments (or not more than 3; you can get away with 2, but in that case the default would return FALSE for the unspecified condition). I've tried to correct your formula without knowing what you're trying to achieve, but at least to give it valid syntax. I got: =IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3) ,IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3,"unspecifi ed output")))) You could lose a few parentheses to make the counting easier: =IF(AND(D3="yes",E3="",K3="M"),G3-I3-(H3+I3+J3),IF(AND(D3="yes",E3="",K3="L"),G3-I3-J3,IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3), IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3,"unspecifie d output")))) You might find it clearer if you group situations like =IF(AND(D3="yes",E3="")... and then separate your K3 conditions after that. -- David Biddulph "petester" wrote in message ... This is my IF / AND statement that I can not get to work. (=IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3))),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))). Does any one have any suggestions to what I am doing incorrectly? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can not seem to get my IF / AND statement to work, help plea
Thank you! The rewrite with fewer parentheses did the trick.
"David Biddulph" wrote: You need to check the matching of the parentheses for each IF statement, and you need to ensure that each IF has 3 arguments (or not more than 3; you can get away with 2, but in that case the default would return FALSE for the unspecified condition). I've tried to correct your formula without knowing what you're trying to achieve, but at least to give it valid syntax. I got: =IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3) ,IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3,"unspecifi ed output")))) You could lose a few parentheses to make the counting easier: =IF(AND(D3="yes",E3="",K3="M"),G3-I3-(H3+I3+J3),IF(AND(D3="yes",E3="",K3="L"),G3-I3-J3,IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3), IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3,"unspecifie d output")))) You might find it clearer if you group situations like =IF(AND(D3="yes",E3="")... and then separate your K3 conditions after that. -- David Biddulph "petester" wrote in message ... This is my IF / AND statement that I can not get to work. (=IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3))),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))). Does any one have any suggestions to what I am doing incorrectly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My IF statement won't work for my formula | Excel Worksheet Functions | |||
How do I get an IS and IF statement to work together in excel? | Excel Worksheet Functions | |||
Anyone actually get Case statement to work ... ? | Excel Worksheet Functions | |||
Why doesn't this nested IF statement work? | Excel Worksheet Functions | |||
Array If statement doesn't work | Excel Worksheet Functions |