Logical
NOT / AND / OR
NOT / AND / OR
What does =NOT(4<2) return?
TRUE, because 4<2 is false.
IF(7>10,"Yes","No") → result?
No, because 7>10 is false.
What is =10/2?
5, because 10 divided by 2 is 5.
What is =ROUND(2.718,2)?
2.72, rounded to 2 decimal places.
=AND(A1<10,B1>3) with A1=8, B1=2 → result?
FALSE, because B1>3 is false.
=IF(B1<50,"Low","High") with B1=75 → result?
High, because B1<50 is false.
What is =MOD(17,5)?
2, because 17 ÷ 5 leaves remainder 2.
=ROUNDUP(4.321,1) → result?
4.4, rounded up to 1 decimal place.
=OR(A1>100,B1<0,C1=50) with A1=90, B1=5, C1=50 → result?
TRUE, because C1=50 is true.
=IF(OR(A1>10,B1<5),"Pass","Fail") with A1=8, B1=3 → result?
Pass, because B1<5 is true.
What is =5^3+MOD(20,6)?
125+2 = 127.
=ROUNDDOWN(9.876,2) → result?
9.87, rounded down to 2 decimals.
=AND(OR(A1=1,B1=2),NOT(C1=3)) with A1=1, B1=5, C1=3 → result?
FALSE, because NOT(C1=3) is false.
=IF(AND(A1>5,B1<10),IF(C1=100,"Yes","No"),"Fail") with A1=6, B1=9, C1=50 → result?
No, because AND is true but C1=100 is false.
What is =(10^2)/(5*2)?
100 ÷ 10 = 10.
=ROUND(123.456,-1) → result?
120, because rounding to -1 digits rounds to nearest 10.