contestada

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.

Respuesta :

problemsolver2019

Answer:

=IF(C5>=H18, "Goal Met", "Review")

Explanation:

The syntax of if the statement is,

=IF( lOGIC expression, THIS IF TRUE, THIS IF FALSE)

Hence, the logical expression is C5>=H18. And if this turns out to be true then the output is going to be Goal Met, and if this turns out to be false, then the output is going to be Review. And thus, we have the above formula that we are required to make use of.

Otras preguntas