Question

In cell M2, enter a formula using a nested IF function as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future: a. If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text.

Answer 1

Answer:

Following are the code to this question:

code:

=IF(EXACT(I2,"Yes"),"Elected",IF(EXACT(K2,"Yes"),"Yes","No"))

Explanation:

In the given the data is not defined so we explain only  the above code, but before that, we briefly define working of if the function that can be defined as follows:

• The If() function, is used only when one of the logical functions and its value must return the value true. or we can say it only return a true value.
• In the above function, a column "Elected" is used that uses other column values to check this column value is equal if this condition is true it will return "yes" value.