Question

In cell H5, enter a formula using the IF function that tests whether the numbe

years is greater than or equal to 4. If it is, display "Y" in cell H5. If it is not,
display "N" in cell

Answer 1

=IF(E10>=4,"Y","N")

Step-by-step explanation:

This was already correctly answered. I'll add some futher explanation.

The "E10>=4" states "The contents of cell E10 are greater than, or equal to, 4. The entry after the comma is the response if the statement is TRUE. The reponse may be a numerical vale, such as 1, a calculation, or taex. Text must be bounded by the quotation marks: "Y". The entry after the last comma is the response if the statement were FALSE. Here, is will return an N.

Answer 2

Formula : =IF(E5>=4, "Y", "N")

Formula Explanation : =IF(cell_name>=4, [value_if_true], [value_if_false]

Step-by-step explanation:

After Writing this Formula in cell H5 Drag it to the cell till where you want.