Excel Nesting Question

[czech09]

I've been working on this for at least 30 minutes now and can't seem to figure this thing out, if anyone could help that'd be great thanks in advance...

Problem:

You are interested in knowing IF the logical test of an AND statement that consists of 0, 1, 1 is true or false.

The result of this AND statement, if true is another IF statement that has B10 as the logical test the word True for the true argument and the word false for the false argument.

The false argument is another IF statement that has B11 as the logical test and then 1 as the true arg. and 0 as the false argument.

The answer to that IF statement is 1/3 arguments in an OR statement. The other 2 arguments are the words True and False

Now the result of the Or is the logical test of an IF that has "ABC" as the true and "DEF" as its false.


This is what I think it is but when I put it into excel it says there's an error somewhere:

=IF(AND(0,1,1 IF(B10, "True", "False" IF(B11, 1, 0 IF(OR("ABC", "DEF"))))))

 

[czech09]

*help*

 

[imported_Mike]

Beyond my excel knowledge at this point. Been so long since I've used it indepth, just remember the basics.

 

[theknight571]

Dang... I don't have Excel on my home laptop...

If you're still needing help tomorrow, I'll take a further look at the problem.

 

[mugs]

Originally posted by: czech09
=IF(AND(0,1,1 IF(B10, "True", "False" IF(B11, 1, 0 IF(OR("ABC", "DEF"))))))

I don't think you can do what's in the bolded parts. I'm still trying to interpret your post to figure out the right formula

Can you describe the conditions you're trying to meet in plain English, not in terms of Excel formulas?

i.e. "If x and y are true or z is true, the value should be q. If x is false and y is true and z is false..." etc.