Saturday, January 17, 2015

AND ,OR and NOT

In Microsoft Excel, there are certain things that can improve the sense of formulas. Such are AND, OR and NOT. All these functions follow the Boolean

Table
The AND Function, ( pronounced as And not as ) returns True if all conditions are true and will return False if any of the conditions is false.

An example is =AND(A1>A10,A1<A40).

The OR Function, returns True if all conditions are true. Unlike the AND Function, the OR Function will return true if any of the conditions are True.

The NOT function, I don't know.

No comments:

Post a Comment