Question

Which functions return a logical value (TRUE or FALSE)?

I
and
functions return a logical value (TRUE or FALSE),

Answer 1

Step-by-step explanation:

AND, NOT. both return a True or False answer.

Answer 2

1. functions that return a logical value:

AND Returns TRUE if all of the arguments evaluate to TRUE. =AND(A2>=10, B2<5)

OR Returns TRUE if any argument evaluates to TRUE. =OR(A2>=10, B2<5)

XOR Returns a logical Exclusive Or of all arguments. =XOR(A2>=10, B2<5)

2. I and functions return a logical value?

TRUE

The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE .

As explained above the AND function return a logical value