Write a formula in cell N4 that can be copied down the column to determine if no decision is made on this applicant. Recall that no decision is made if the applicant is both not automatically disqualified (K) and not automatically hired (M).
Spreadsheet model is not provided, where the formula is required .
However, explaining using hypothetical addresses
hypothetical address K4 of the cell which tells where the candidate is not automatically disqualified (K)
hypothetical address M4 of the cell which tells where the candidate is not automatically hired (M)
then the formula to determine the decision status is following:
=AND(K4<>"K", M4<>"M")
The result of this formula will be TRUE indicating that no decision is made, if the applicant is both not automatically disqualified (K) and not automatically hired (M). In other words, if the value in cell K4 is not equal to "K" AND the value in cell M4 is not equal to "M", then the result of the cell N4 will be TRUE
If either one or both the conditions are not satisfied, then the result of the formula will be FALSE, indicating that a decision is made.
NOTE: in this formula, i have used K4 and M4 as hypothetical addresses of the cells, you need to use the actual address of the cell in Excel, which carry information about K and M status of the candidate
Get Answers For Free
Most questions answered within 1 hours.