Question

In cell F4 on the Ranger-led Activities worksheet, what formula should be added to display "Yes" if the National Park offers both Youth Programs and Astronomy Programs, and "No" otherwise?

a) =IF(AND(B4="Yes", C4="Yes"), "Yes", "No")
b) =IF(OR(B4="Yes", C4="Yes"), "Yes", "No")
c) =IF(B4="Yes" + C4="Yes", "Yes", "No")
d) =IF(B4="Yes" * C4="Yes", "Yes", "No")

Answer 1

The correct formula to display "Yes" if both Youth Programs and Astronomy Programs are offered is =IF(AND(B4="Yes", C4="Yes"), "Yes", "No"). This formula uses the IF function combined with the AND function to require both conditions to be true.

Step-by-step explanation:

To determine whether a National Park offers both Youth Programs and Astronomy Programs, and display "Yes" only if both are offered, you should use an IF function combined with the AND function in Excel. The correct formula would be: =IF(AND(B4="Yes", C4="Yes"), "Yes", "No")

This formula checks if both cells B4 and C4 contain the text "Yes". If they do, the function returns "Yes"; if not, it returns "No". The AND function ensures that both conditions must be true for "Yes" to be displayed in cell F4 on the Ranger-led Activities worksheet.

Therefore, the correct answer is a) =IF(AND(B4="Yes", C4="Yes"), "Yes", "No").