St-Lim,

Your formulas are working as they should.

**AND**: `=if(And(B2,C2>3), "Yes", "No")`

With input Cell B2=4 and Cell C2=3, the answer "No" is correct. B2 evaluates to True. C2 is not greater than 3 so that evaluates to False. True and False = False.

With input Cell B2=1 and Cell C2=5, the answer "Yes" is correct. B2 evaluates to True. C2 is greater than 3 so that evaluates to True.

True and True = True

**OR**: `=if(Or(B2,C2>3), "yes","No")`

With input Cell B2=3, and Cell C2=4, the answer should be "Yes" Any non-zero numeric values in B2 will evaluate to True. 4 is greater than 3 so C2>3 also evaluates to True.

True or True = True.

With input Cell B2=0, and Cell C2=4, the answer should also be "Yes"

B2 = 0 is False, 4 is greater than 3.
False or True = True.

With input Cell B2=0, and Cell C2=1, the answer should be "No"

B2 = 0 is False, 1 is NOT greater than 3.
False or False = False.