Question

7.In cell N2, enter a formula using the IF function as follows to determine which work tier Kay Colbert is qualified for: a.The IF function should determine if the student's Post-Secondary Years is greater than or equal to 4, and return the value 2 if true or the value 1 if false.

Answer 1

Ans a) I will paste three screenshots where the working of if function is shown as required in the question

Refer the if function mentioned in the formula bar in below snap

Case 1 - If Post - Secondary years = 1

Expected result - N2 should give value as 1 Actual result = 1

So the formula is ok for this case

Case 2 - If Post - Secondary years = 4

Expected result - N2 should give value as 2 Actual result = 2

So the formula is ok for this case

Case 3 - If Post - Secondary years = 5

Expected result - N2 should give value as 2 Actual result = 2

So the formula is ok for this case

For all the three cases the formula works --So it is a correct formula.

P.S --Kindly give thumbs up --This will motivate me to provide more and more quality answers!