Question

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 1

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)