Ask 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 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. 29 September, 05:42
    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?
Find 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 the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers