contestada

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

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 dis class=

Respuesta :

syedyahyahabib

Answer:

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

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

Explanation:

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

rspill6

Answer:

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

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.