the current formula I have is: =IF(B3="mammal",IF(OR(B4="SOME",B4="MUCH"),IF(B5="NO",IF(B6="NO","Deer","N/A"))),IF(B3="Amphibian",IF(B4="NONE",IF(B5="NO",IF(B6="NO","Frog","N/A"))))

Whenever I add more it says too many arguments.

4. (20 points) This question will introduce you to another useful tool and that is conditional statements. These are also sometimes called "IF-THEN" statements. You are already familiar with these types of statements in your life. Some examples of these statements in common language are shown below. For example, we could craft this statement: "If a man is your father's brother, then he is your uncle." Here the condition that we must satisfy is that the man in question is your father's brother, and when that is satisfied we say that this man is your uncle. Example We can take this a bit further by including an "AND" condition: "If a person is a man AND your father's brother, then that person is your uncle." Here we have to satisfy both conditions for the person we are considering to be labeled as your uncle. Similar to this we can perform what is called a nested IF: "If a person is a man, then if that man is your father's brother then he is your uncle and if that man is your father's son then he is your brother." Here we first consider if the person is a man, then we consider some other conditions to classify the man as either your uncle or your brother based on their relation to your dad. When we use the in Excel, we can cause a cell to display a particular value based on the contents of another cell and if the contents of the other cell meet the criteria in the statement. The IF equation in Excel is formatted as follows. The value/action can either be something to display a value or to perform another command in Excel (including another IF). =IF (condition, value/action if condition met, value/action if condition not met) For example, we could enter a person's gender in cell A1 and their relationship to your father in B1, and to classify this person as either your uncle or your brother in C1 , we could type the following. Note that we should provide a result for true and false conditions for each "IF." =IF(A1="Man",IF(B1="Brother","Uncle",IF(B1="Son","Brother","N/A")),"N/A") Here we are working with text as both the input in cells A1 and B1 and as the output in cell C1; hence, all values are in quotation marks. You can enter equations or numerical values without the quotation marks. Now let's put this into practice. If you go to the tab in the provided Excel sheet for this question, you will see where we have the template for an animal classification game. You will need to create a spreadsheet that will conclude which of the listed animals that you are considering based on the input of the animal's class, whether it has visible fur/hair, whether it is venomous, and whether it is poisonous. Note that the answer options have already been made into a drop-down list in each of the cells so the person using your spreadsheet can select from the available options. Now, this is not a class on animals, and I also don't want complaints about my imperfect taxonomy, so here are the characteristics that you should use to identify each animal. - Deer - Class: Mammal, Visible Hair/Fur: Some OR Much, Venomous: No, Poisonous: No - Frog - Class: Amphibian, Visible Hair/Fur: None, Venomous: No, Poisonous: Some - Snake - Class: Reptile, Visible Hair/Fur: None, Venomous: Some, Poisonous: No - Elephant - Class: Mammal, Visible Hair/Fur: No, Venomous: No, Poisonous: No \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Animal Classification } \\ \hline Class? & Reptile \\ \hline Visible Fur/Hair? & NONE \\ \hline Venomous? & SOME \\ \hline Poisonous? & NO \\ \hline \end{tabular} ANSWER OPTIONS \begin{tabular}{|c|c|c|c|} \hline Class & Visible Fur/Hair & Venomous & Poisonous \\ \hline Mammal & NONE & YES & YES \\ \hline Reptile & SOME & NO & NO \\ \hline Amphibian & MUCH & SOME & SOME \\ \hline \multicolumn{5}{|c|}{ Possible types of animals } & \\ \hline Deer & Frog & Snake & Elephant \\ \hline \end{tabular} What type of animal do I have? FALSE