Assume you to create a formula in Excel that chooses great baseball teams

Excel has the following table

You would like to create logic that assigns a value of 1 to Great Teams, and a value of 0 to the other teams using an If-Then Statement in Excel

You will create the formula for cell F2 and then fill down.

For this exercise, you know that teams from Texas are automatically great teams, and that League Titles (perhaps you feel World Series Titles are too much a matter of chance since both teams are great) are the most important measure of the great teams, so if a team is not from Texas, it is still a Great Team (=1) if it has 4 or more League Titles.

Which of the following if then statements will assign a value of 1 to teams from Texas (Column B=1) or Teams 4 or more League Titles (Column D greater than or equal to 4) There may be more than one correct answer

a		=IF(OR(IF(B2,1,0),IF(D2>=4,1,0)),1,0)
b		=IF(AND(IF(B2,0,1),IF(D2>=4,0,1)),0,1)
c		=IF(B2,1,IF(D2>3,1,0))
d		=IF(OR(B2,D2>=4),1,0)
e		=IF(AND(B2=0,D2
f		=IF(AND(NOT(B2),D2

\begin{tabular}{||l|l|l|l|l|l||l||} \hline \hline & A & B & C & D & E & F \\ \hline 1 & Team number & From Texas & Wins & League Titles & World Series Titles & Great Team \\ \hline \hline 2 & 1 & 0 & 80 & 3 & ? \\ \hline 3 & 2 & 1 & 50 & 2 & 2 & ? \\ \hline 4 & 3 & 60 & 4 & 1 & ? \\ \hline 5 & 4 & 0 & 90 & 7 & 0 & ? \\ \hline \end{tabular} \begin{tabular}{||l|l|l|l|l|l||l||} \hline \hline & A & B & C & D & E & F \\ \hline 1 & Team number & From Texas & Wins & League Titles & World Series Titles & Great Team \\ \hline \hline 2 & 1 & 0 & 80 & 3 & ? \\ \hline 3 & 2 & 1 & 50 & 2 & 2 & ? \\ \hline 4 & 3 & 60 & 4 & 1 & ? \\ \hline 5 & 4 & 0 & 90 & 7 & 0 & ? \\ \hline \end{tabular}