In cell M2, enter a formula using a nested IF function as follows to determine first if a student has already been elected to of

Question

3 years ago

12

In cell M2, enter a formula using a nested IF function as follows to determine first if a student has already been elected to of

fice 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.

Computers and Technology

1 answer:

aleksley [76] · Answer 1 · 2022-06-17T02:25:51+03:00

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.