Question

Que. No. 5
If cell A3 contains 10 and cell A4 contains 20, then what is the return value of the formula =OR(A3 > 5, A4 < 12)
O A) 10
B) 30
C) False
D) True​

Answer 1

Answer.

• The formula returns - TRUE.

Explanation.

In excel, the OR function is used to check multiple conditions.

Here, the conditions given are -

1. A3 > 5
2. A4 < 12

A3 > 5

= 10 > 5

= TRUE

A4 < 12

= 20 < 12

= FALSE

Note that if any condition is TRUE, the OR function returns true.

So, the formula =OR(A3 > 5, A4 < 12) returns TRUE.

See attachment for verification.