Ask Question
15 June, 16:23

On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18. The function should return the text Goal Met if true and Review if false. Set the reference to cell H18 as an absolute reference.

+3
Answers (1)
  1. 15 June, 16:38
    0
    =IF (K5>=H18,"Goal Met", "Review")

    Explanation:

    The syntax of if the statement is as below:

    =If (logic test, if true then this, if false then this)

    And hence, and as in question logic test is k5>=H18, and on true the output should be Goal met, and on false the output should be review. And hence, we get the above formula, and which is the required answer.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers