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.

Question

Computers and Technology

Papa

11 March, 19:39

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.

+2

Answers (1)

Know the Answer?

Cooley · Answer 1

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