NiroshaJayasinghe
Heres the same answer Mahishara told but with more explanation:
The table shows three logical expressions:
The first two expressions are simple comparisons. The first expression =2>=1
is true because 2 is greater than or equal to 1. The second expression ="A">"B"
is false because the text "A" is not greater than the text "B".
The third expression is a compound logical expression that uses the AND
operator. The AND
operator returns TRUE only if both of its operands are TRUE. In this case, the first operand 2>=1
is TRUE, but the second operand ="A">"B"
is FALSE. Therefore, the entire expression =AND(2>=1,"A">"B")
is FALSE.
The statement "A2 and A3 shows FALSE" is correct. Both A2 and A3 are FALSE.