This is all one formula


i. You are interested in knowing IF the logical test of an AND statement that consists of a zero, one, and another one (use the ordinal number value), is true or false.

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

iii.The false argument is another IF statement that has B11 as the logical test, then 1 followed by a 0 for the true and false arguments respectively. The answer to that IF statement is one of the three arguments in an OR statement. The other two arguments are the words True or False.

iv. Now the result of this Or is the logical test of an IF that has "CGS2531 is Great!" as its true argument and "CGS2531 is the Best!" as its false argument.



Any help would be awesome, and I truly appreciate it. I gave it a shot and got to here, but gave up as I couldnt figure it out.

=IF(And(0,1,1,IF(B10,"True",IF(B11,1,0,OR("TRUE"," FALSE"

 

Jimmy Carter any help?

 

=if(and(0,1,1),if(b10,"True","False"),if(if(b11=TR UE(),1,0)),if(OR("TRUE","FALSE"),"CGS2531 is Great","CGS2531 is the Best!))

Maybe Don't have excel at home so this is just a guess. If you need more help on the parameters for each function check the help menu in excel. It'll let you know if you've got all your bases covered.

 

didnt work for me, but thanks for your attempt, i appreciate it!

 

What are you trying to accomplish?

 

Im trying to accomplish a dumbass school project

 

I fooled around with it for a bit, but the formula nesting got out of control to the point that it was almost unmanageable, and Excel spit on me.

 

The parentheses are definitely a problem today.