Question

Write the formula of AND, OR and NOT function with example?​

Answer 1

Answer:

Explanation:

If we wish to test several conditions in a single formula, then we can use NOT in conjunction with the AND or OR function. For example, if we wanted to exclude Red Blue and Slate Black, the formula would be =NOT(OR(C2=”Slate black”, C2=”Red Blue”).