Question

List any three logical function with example of each?​

Answer 1

Answer:

Excel logical functions - overview

Function Description Formula Example

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)

HOPE IT'LL HELP