Answered

The score of a student in two subjects are inserted in the B2 and C2 cells and the passing score for each subject is 60. Which of these functions will you insert in the D2 cell so that it returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE

Answer :

pedrocarratore

Answer:

=OR(B2>=60, C2>=60)

Explanation:

If you want to check if at least one of the scores is equal to or greater than 60, you should use the OR function. The OR function tests multiple conditions and returns TRUE if at least one is met. Therefore, the function in cell D2 would be:

= OR(B2>=60, C2>=60)

fichoh

In other to obtain the boolean value True if one of two or more conditions are met, the OR operator is used. Hence, the appropriate function is =OR(B2>=60, C2>=60)

  • The OR opertor gives a True value if one of the two conditions is met., if the student scores 60 or above in one of the two subjects, the output will be True.

  • Similarly, if the student score above 60 in both, the output will be true.

Hence, the appropriate function is =OR(B2>=60, C2>=60).

Learn more : https://brainly.com/question/20702793

Other Questions